Get value set function

sample FF to get the value set information


DEFAULT FOR CMP_ASSIGNMENT_SALARY_ANNUAL_AMOUNT  IS -1
DEFAULT FOR PER_ASG_FTE_VALUE  IS 0
INPUTS ARE CMP_IV_PERIOD_ID (Text),CMP_IV_PERIOD_START_DATE (date),CMP_IV_PERIOD_END_DATE (Date)
L_BIND = '|=TYPE_CODE=''CMP_TCS_COLS_BNFTS''|LOOKUP_CODE=CNTRB'
L_FILER= 'Company'
L_DATA = ESS_LOG_WRITE( 'BEGIN CS_FTE_SAL_TEST_FF' ) 
/*COMPENSATION_DATE =  TO_CHAR(CMP_IV_PERIOD_END_DATE, 'YYYY/MM/DD') */
VALUES = GET_VALUE_SET('KP_VALUE_SET',L_BIND,L_FILER)
L_DATA =ESS_LOG_WRITE('DISTINCT MEANING VALUES ARE' + VALUES )
RETURN VALUES

Comments