APPS.PY_ZA_TX_UTL_01032007 dependencies on FF_GLOBALS_F

Line 183: (p_GlbNme ff_globals_f.global_name%TYPE

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

Line 185: ) RETURN ff_globals_f.global_value%TYPE

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

Line 196: FROM ff_globals_f

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

Line 2281: FROM ff_globals_f

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

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

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

Line 2411: FROM ff_globals_f

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

Line 2426: FROM ff_globals_f

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