APPS.PY_ZA_TX_UTL_01032006 dependencies on FF_GLOBALS_F

Line 182: (p_GlbNme ff_globals_f.global_name%TYPE

178: -------------------------------------------------------------------------------
179: -- GlbVal --
180: -------------------------------------------------------------------------------
181: FUNCTION GlbVal
182: (p_GlbNme ff_globals_f.global_name%TYPE
183: ,p_EffDte DATE
184: ) RETURN ff_globals_f.global_value%TYPE
185: AS
186: -- Variables

Line 184: ) RETURN ff_globals_f.global_value%TYPE

180: -------------------------------------------------------------------------------
181: FUNCTION GlbVal
182: (p_GlbNme ff_globals_f.global_name%TYPE
183: ,p_EffDte DATE
184: ) RETURN ff_globals_f.global_value%TYPE
185: AS
186: -- Variables
187: l_GlbVal t_balance;
188: BEGIN

Line 195: FROM ff_globals_f

191: WriteHrTrace('p_EffDte :'||to_char(p_EffDte,'DD/MM/YYYY'));
192: --
193: SELECT TO_NUMBER(global_value)
194: INTO l_GlbVal
195: FROM ff_globals_f
196: WHERE p_EffDte between effective_start_date and effective_end_date
197: AND global_name = p_GlbNme;
198:
199: hr_utility.set_location('py_za_tx_utl_01032006.GlbVal',2);

Line 2279: FROM ff_globals_f

2275: )
2276: IS
2277: SELECT effective_end_date
2278: , to_number(global_value) global_value
2279: FROM ff_globals_f
2280: WHERE effective_end_date < p_ty_ed
2281: AND effective_end_date > p_ty_sd
2282: AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';
2283:

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

2290: l_CurRfiYtd t_balance DEFAULT 0;
2291: l_TotRfiYtd t_balance DEFAULT 0;
2292: l_CurTxbRfi t_balance DEFAULT 0;
2293: l_TotTxbRfi t_balance DEFAULT 0;
2294: l_GlbVal ff_globals_f.global_value%TYPE DEFAULT '0';
2295:
2296: BEGIN
2297: hr_utility.set_location('py_za_tx_utl_01032006.TrvAll',1);
2298: -- Retrieve Balance Type ID's

Line 2409: FROM ff_globals_f

2405: l_RfiYtd := py_za_tx_01032006.bal_TOT_TXB_TA_PTD;
2406: -- Global Value
2407: SELECT TO_NUMBER(global_value)
2408: INTO l_GlbVal
2409: FROM ff_globals_f
2410: WHERE l_EndDate between effective_start_date
2411: and effective_end_date
2412: AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';
2413:

Line 2424: FROM ff_globals_f

2420:
2421: -- Global Value
2422: SELECT TO_NUMBER(global_value)
2423: INTO l_GlbVal
2424: FROM ff_globals_f
2425: WHERE l_EndDate between effective_start_date
2426: and effective_end_date
2427: AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';
2428: