APPS.PY_ZA_TX_UTL_01032005 dependencies on FF_GLOBALS_F

Line 193: (p_GlbNme ff_globals_f.global_name%TYPE

189: -------------------------------------------------------------------------------
190: -- GlbVal --
191: -------------------------------------------------------------------------------
192: FUNCTION GlbVal
193: (p_GlbNme ff_globals_f.global_name%TYPE
194: ,p_EffDte DATE
195: ) RETURN ff_globals_f.global_value%TYPE
196: AS
197: -- Variables

Line 195: ) RETURN ff_globals_f.global_value%TYPE

191: -------------------------------------------------------------------------------
192: FUNCTION GlbVal
193: (p_GlbNme ff_globals_f.global_name%TYPE
194: ,p_EffDte DATE
195: ) RETURN ff_globals_f.global_value%TYPE
196: AS
197: -- Variables
198: l_GlbVal t_balance;
199: BEGIN

Line 206: FROM ff_globals_f

202: WriteHrTrace('p_EffDte :'||to_char(p_EffDte,'DD/MM/YYYY'));
203: --
204: SELECT TO_NUMBER(global_value)
205: INTO l_GlbVal
206: FROM ff_globals_f
207: WHERE p_EffDte between effective_start_date and effective_end_date
208: AND global_name = p_GlbNme;
209:
210: hr_utility.set_location('py_za_tx_utl_01032005.GlbVal',2);

Line 2151: FROM ff_globals_f

2147: )
2148: IS
2149: SELECT effective_end_date
2150: , to_number(global_value) global_value
2151: FROM ff_globals_f
2152: WHERE effective_end_date < p_ty_ed
2153: AND effective_end_date > p_ty_sd
2154: AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';
2155:

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

2162: l_CurRfiYtd t_balance DEFAULT 0;
2163: l_TotRfiYtd t_balance DEFAULT 0;
2164: l_CurTxbRfi t_balance DEFAULT 0;
2165: l_TotTxbRfi t_balance DEFAULT 0;
2166: l_GlbVal ff_globals_f.global_value%TYPE DEFAULT '0';
2167:
2168: BEGIN
2169: hr_utility.set_location('py_za_tx_utl_01032005.TrvAll',1);
2170: -- Retrieve Balance Type ID's

Line 2281: FROM ff_globals_f

2277: l_RfiYtd := py_za_tx_01032005.bal_TOT_TXB_TA_PTD;
2278: -- Global Value
2279: SELECT TO_NUMBER(global_value)
2280: INTO l_GlbVal
2281: FROM ff_globals_f
2282: WHERE l_EndDate between effective_start_date
2283: and effective_end_date
2284: AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';
2285:

Line 2296: FROM ff_globals_f

2292:
2293: -- Global Value
2294: SELECT TO_NUMBER(global_value)
2295: INTO l_GlbVal
2296: FROM ff_globals_f
2297: WHERE l_EndDate between effective_start_date
2298: and effective_end_date
2299: AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';
2300: