DBA Data[Home] [Help]

APPS.PY_ZA_TX_01011001 dependencies on FF_GLOBALS_F

Line 1617: FROM ff_globals_f

1613: )
1614: IS
1615: SELECT effective_end_date,
1616: to_number(global_value) global_value
1617: FROM ff_globals_f
1618: WHERE effective_end_date < p_ty_ed
1619: AND effective_end_date > p_ty_sd
1620: AND effective_end_date < dbi_ZA_CUR_PRD_END_DTE
1621: AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';

Line 1767: FROM ff_globals_f

1763: )
1764: IS
1765: SELECT effective_end_date,
1766: global_value
1767: FROM ff_globals_f
1768: WHERE effective_end_date > p_StrtDte
1769: AND effective_end_date < p_EndDte
1770: AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';
1771:

Line 1872: FROM ff_globals_f

1868: -- Retrieve the Global value effective on l_EndDate
1869: --
1870: SELECT TO_NUMBER(global_value)
1871: INTO l_GlbVal
1872: FROM ff_globals_f
1873: WHERE l_EndDate between effective_start_date and effective_end_date
1874: AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';
1875: -- Nrfi Travel Allowance
1876: --