APPS.PY_ZA_TX_UTL_01032011 dependencies on FF_GLOBALS_F

Line 219: (p_GlbNme ff_globals_f.global_name%TYPE

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

Line 221: ) RETURN ff_globals_f.global_value%TYPE

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

Line 232: FROM ff_globals_f

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

Line 2849: FROM ff_globals_f

2845: )
2846: IS
2847: SELECT effective_end_date
2848: , to_number(global_value) global_value
2849: FROM ff_globals_f
2850: WHERE effective_end_date < p_ty_ed
2851: AND effective_end_date > p_ty_sd
2852: AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';
2853:

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

2860: l_CurRfiYtd t_balance DEFAULT 0;
2861: l_TotRfiYtd t_balance DEFAULT 0;
2862: l_CurTxbRfi t_balance DEFAULT 0;
2863: l_TotTxbRfi t_balance DEFAULT 0;
2864: l_GlbVal ff_globals_f.global_value%TYPE DEFAULT '0';
2865:
2866: BEGIN
2867: hr_utility.set_location('py_za_tx_utl_01032011.TrvAll',1);
2868: -- Retrieve Balance Type ID's

Line 2979: FROM ff_globals_f

2975: l_RfiYtd := py_za_tx_01032011.bal_TOT_TXB_TA_PTD;
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:

Line 2994: FROM ff_globals_f

2990:
2991: -- Global Value
2992: SELECT TO_NUMBER(global_value)
2993: INTO l_GlbVal
2994: FROM ff_globals_f
2995: WHERE l_EndDate between effective_start_date
2996: and effective_end_date
2997: AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';
2998: