APPS.PY_ZA_TX_UTL_01032002 dependencies on FF_GLOBALS_F

Line 191: (p_GlbNme ff_globals_f.global_name%TYPE

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

Line 193: ) RETURN ff_globals_f.global_value%TYPE

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

Line 204: FROM ff_globals_f

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

Line 2097: FROM ff_globals_f

2093: )
2094: IS
2095: SELECT effective_end_date
2096: , to_number(global_value) global_value
2097: FROM ff_globals_f
2098: WHERE effective_end_date < p_ty_ed
2099: AND effective_end_date > p_ty_sd
2100: AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';
2101:

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

2114: l_CurRfiYtd t_balance DEFAULT 0;
2115: l_TotRfiYtd t_balance DEFAULT 0;
2116: l_CurTxbRfi t_balance DEFAULT 0;
2117: l_TotTxbRfi t_balance DEFAULT 0;
2118: l_GlbVal ff_globals_f.global_value%TYPE DEFAULT '0';
2119:
2120: BEGIN
2121: hr_utility.set_location('py_za_tx_utl_01032002.TrvAll',1);
2122: -- Retrieve Balance Type ID's

Line 2303: FROM ff_globals_f

2299: l_RfiYtd := py_za_tx_01032002.bal_TA_RFI_PTD;
2300: -- Global Value
2301: SELECT TO_NUMBER(global_value)
2302: INTO l_GlbVal
2303: FROM ff_globals_f
2304: WHERE l_EndDate between effective_start_date
2305: and effective_end_date
2306: AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';
2307:

Line 2319: FROM ff_globals_f

2315:
2316: -- Global Value
2317: SELECT TO_NUMBER(global_value)
2318: INTO l_GlbVal
2319: FROM ff_globals_f
2320: WHERE l_EndDate between effective_start_date
2321: and effective_end_date
2322: AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';
2323: