Below is a Sample Formula shows How to Call a Value set in Fast Formula :
Inputs are hr_id (number),
eff_st_date(text),
eff_end_date(text),
mode (text)
l_hr_per_id = hr_id
l_eff_st_date = eff_st_date
l_eff_end_date = eff_end_date
X_OUTPUT = ‘0001/01/01 00:00:00’ (DATE)
X_OUTPUT_NUMBER = 0
X_OUTPUT_TEXT = ‘ ‘
IF mode = ‘GROSS’ THEN
(
X_OUTPUT_TEXT = GET_VALUE_SET ( ‘AH_GET_GROSS_YTD_VALUE’ , ‘|=L_PERSON_ID=”’|| TO_CHAR(l_hr_per_id)||””||’|L_CMP_START_DATE=”’|| l_eff_st_date ||””||’|L_CMP_END_DATE=”’|| l_eff_end_date ||””)
)
ELSE
(
X_OUTPUT_TEXT = ‘0’
)
RETURN X_OUTPUT_TEXT
Queries
Do drop a note by writing us at doyen.ebiz@gmail.com or use the comment section below to ask your questions
Recent Posts
