APPS.PY_ZA_TX_UTL_01032013 dependencies on FF_GLOBALS_F

Line 226: (p_GlbNme ff_globals_f.global_name%TYPE

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

Line 228: ) RETURN ff_globals_f.global_value%TYPE

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

Line 239: FROM ff_globals_f

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

Line 2955: FROM ff_globals_f

2951: )
2952: IS
2953: SELECT effective_end_date
2954: , to_number(global_value) global_value
2955: FROM ff_globals_f
2956: WHERE effective_end_date < p_ty_ed
2957: AND effective_end_date > p_ty_sd
2958: AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';
2959:

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

2966: l_CurRfiYtd t_balance DEFAULT 0;
2967: l_TotRfiYtd t_balance DEFAULT 0;
2968: l_CurTxbRfi t_balance DEFAULT 0;
2969: l_TotTxbRfi t_balance DEFAULT 0;
2970: l_GlbVal ff_globals_f.global_value%TYPE DEFAULT '0';
2971:
2972: BEGIN
2973: hr_utility.set_location('py_za_tx_utl_01032013.TrvAll',1);
2974: -- Retrieve Balance Type ID's

Line 3085: FROM ff_globals_f

3081: l_RfiYtd := py_za_tx_01032013.bal_TOT_TXB_TA_PTD;
3082: -- Global Value
3083: SELECT TO_NUMBER(global_value)
3084: INTO l_GlbVal
3085: FROM ff_globals_f
3086: WHERE l_EndDate between effective_start_date
3087: and effective_end_date
3088: AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';
3089:

Line 3100: FROM ff_globals_f

3096:
3097: -- Global Value
3098: SELECT TO_NUMBER(global_value)
3099: INTO l_GlbVal
3100: FROM ff_globals_f
3101: WHERE l_EndDate between effective_start_date
3102: and effective_end_date
3103: AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';
3104: