APPS.PY_ZA_TX_UTL_01032012 dependencies on FF_GLOBALS_F

Line 227: (p_GlbNme ff_globals_f.global_name%TYPE

223: -------------------------------------------------------------------------------
224: -- GlbVal --
225: -------------------------------------------------------------------------------
226: FUNCTION GlbVal
227: (p_GlbNme ff_globals_f.global_name%TYPE
228: ,p_EffDte DATE
229: ) RETURN ff_globals_f.global_value%TYPE
230: AS
231: -- Variables

Line 229: ) RETURN ff_globals_f.global_value%TYPE

225: -------------------------------------------------------------------------------
226: FUNCTION GlbVal
227: (p_GlbNme ff_globals_f.global_name%TYPE
228: ,p_EffDte DATE
229: ) RETURN ff_globals_f.global_value%TYPE
230: AS
231: -- Variables
232: l_GlbVal t_balance;
233: BEGIN

Line 240: FROM ff_globals_f

236: WriteHrTrace('p_EffDte :'||to_char(p_EffDte,'DD/MM/YYYY'));
237: --
238: SELECT TO_NUMBER(global_value)
239: INTO l_GlbVal
240: FROM ff_globals_f
241: WHERE p_EffDte between effective_start_date and effective_end_date
242: AND global_name = p_GlbNme;
243:
244: hr_utility.set_location('py_za_tx_utl_01032012.GlbVal',2);

Line 2894: FROM ff_globals_f

2890: )
2891: IS
2892: SELECT effective_end_date
2893: , to_number(global_value) global_value
2894: FROM ff_globals_f
2895: WHERE effective_end_date < p_ty_ed
2896: AND effective_end_date > p_ty_sd
2897: AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';
2898:

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

2905: l_CurRfiYtd t_balance DEFAULT 0;
2906: l_TotRfiYtd t_balance DEFAULT 0;
2907: l_CurTxbRfi t_balance DEFAULT 0;
2908: l_TotTxbRfi t_balance DEFAULT 0;
2909: l_GlbVal ff_globals_f.global_value%TYPE DEFAULT '0';
2910:
2911: BEGIN
2912: hr_utility.set_location('py_za_tx_utl_01032012.TrvAll',1);
2913: -- Retrieve Balance Type ID's

Line 3024: FROM ff_globals_f

3020: l_RfiYtd := py_za_tx_01032012.bal_TOT_TXB_TA_PTD;
3021: -- Global Value
3022: SELECT TO_NUMBER(global_value)
3023: INTO l_GlbVal
3024: FROM ff_globals_f
3025: WHERE l_EndDate between effective_start_date
3026: and effective_end_date
3027: AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';
3028:

Line 3039: FROM ff_globals_f

3035:
3036: -- Global Value
3037: SELECT TO_NUMBER(global_value)
3038: INTO l_GlbVal
3039: FROM ff_globals_f
3040: WHERE l_EndDate between effective_start_date
3041: and effective_end_date
3042: AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';
3043: