APPS.PY_ZA_TX_UTL_01032009 dependencies on FF_GLOBALS_F

Line 217: (p_GlbNme ff_globals_f.global_name%TYPE

213: -------------------------------------------------------------------------------
214: -- GlbVal --
215: -------------------------------------------------------------------------------
216: FUNCTION GlbVal
217: (p_GlbNme ff_globals_f.global_name%TYPE
218: ,p_EffDte DATE
219: ) RETURN ff_globals_f.global_value%TYPE
220: AS
221: -- Variables

Line 219: ) RETURN ff_globals_f.global_value%TYPE

215: -------------------------------------------------------------------------------
216: FUNCTION GlbVal
217: (p_GlbNme ff_globals_f.global_name%TYPE
218: ,p_EffDte DATE
219: ) RETURN ff_globals_f.global_value%TYPE
220: AS
221: -- Variables
222: l_GlbVal t_balance;
223: BEGIN

Line 230: FROM ff_globals_f

226: WriteHrTrace('p_EffDte :'||to_char(p_EffDte,'DD/MM/YYYY'));
227: --
228: SELECT TO_NUMBER(global_value)
229: INTO l_GlbVal
230: FROM ff_globals_f
231: WHERE p_EffDte between effective_start_date and effective_end_date
232: AND global_name = p_GlbNme;
233:
234: hr_utility.set_location('py_za_tx_utl_01032009.GlbVal',2);

Line 2834: FROM ff_globals_f

2830: )
2831: IS
2832: SELECT effective_end_date
2833: , to_number(global_value) global_value
2834: FROM ff_globals_f
2835: WHERE effective_end_date < p_ty_ed
2836: AND effective_end_date > p_ty_sd
2837: AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';
2838:

Line 2849: l_GlbVal ff_globals_f.global_value%TYPE DEFAULT '0';

2845: l_CurRfiYtd t_balance DEFAULT 0;
2846: l_TotRfiYtd t_balance DEFAULT 0;
2847: l_CurTxbRfi t_balance DEFAULT 0;
2848: l_TotTxbRfi t_balance DEFAULT 0;
2849: l_GlbVal ff_globals_f.global_value%TYPE DEFAULT '0';
2850:
2851: BEGIN
2852: hr_utility.set_location('py_za_tx_utl_01032009.TrvAll',1);
2853: -- Retrieve Balance Type ID's

Line 2964: FROM ff_globals_f

2960: l_RfiYtd := py_za_tx_01032009.bal_TOT_TXB_TA_PTD;
2961: -- Global Value
2962: SELECT TO_NUMBER(global_value)
2963: INTO l_GlbVal
2964: FROM ff_globals_f
2965: WHERE l_EndDate between effective_start_date
2966: and effective_end_date
2967: AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';
2968:

Line 2979: FROM ff_globals_f

2975:
2976: -- Global Value
2977: SELECT TO_NUMBER(global_value)
2978: INTO l_GlbVal
2979: FROM ff_globals_f
2980: WHERE l_EndDate between effective_start_date
2981: and effective_end_date
2982: AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';
2983: