Details to get the document Name in FF
DBI to get the Document Name and Short Name in the TM Module
DEFAULT_DATA_VALUE for HRA_TMPL_PERIODS_CUSTOMARY_NAME is 'XX'
DEFAULT_DATA_VALUE for HRA_TMPL_PERIODS_SHORT_NAME is 'XX'
Loop to get the name
i = 1
while HRA_TMPL_PERIODS_SHORT_NAME.exists(i)LOOP
(
l_short_Name = HRA_TMPL_PERIODS_SHORT_NAME[i]
l_document Name = HRA_TMPL_PERIODS_CUSTOMARY_NAME[i]
i = i+1
)
Query to get the Review period
Select TO_char(START_DATE,'YYYY') from HRT_REVIEW_PERIODS_B
where sysdate between START_DATE AND END_DATE
Tagged:
0