APPS.PY_ZA_TX_UTL_01082000 dependencies on FF_GLOBALS_F

Line 194: (p_GlbNme ff_globals_f.global_name%TYPE

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

Line 196: ) RETURN ff_globals_f.global_value%TYPE

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

Line 207: FROM ff_globals_f

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

Line 2210: FROM ff_globals_f

2206: )
2207: IS
2208: SELECT effective_end_date
2209: , to_number(global_value) global_value
2210: FROM ff_globals_f
2211: WHERE effective_end_date < p_ty_ed
2212: AND effective_end_date > p_ty_sd
2213: AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';
2214:

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

2227: l_CurRfiYtd NUMBER(15,2) DEFAULT 0;
2228: l_TotRfiYtd NUMBER(15,2) DEFAULT 0;
2229: l_CurTxbRfi NUMBER(15,2) DEFAULT 0;
2230: l_TotTxbRfi NUMBER(15,2) DEFAULT 0;
2231: l_GlbVal ff_globals_f.global_value%TYPE DEFAULT '0';
2232:
2233: BEGIN
2234: hr_utility.set_location('py_za_tx_utl_01082000.TrvAll',1);
2235: -- Retrieve Balance Type ID's

Line 2417: FROM ff_globals_f

2413: l_RfiYtd := py_za_tx_01082000.bal_TA_RFI_PTD;
2414: -- Global Value
2415: SELECT TO_NUMBER(global_value)
2416: INTO l_GlbVal
2417: FROM ff_globals_f
2418: WHERE l_EndDate between effective_start_date and effective_end_date
2419: AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';
2420:
2421: hr_utility.set_location('py_za_tx_utl_01082000.TrvAll',17);

Line 2432: FROM ff_globals_f

2428:
2429: -- Global Value
2430: SELECT TO_NUMBER(global_value)
2431: INTO l_GlbVal
2432: FROM ff_globals_f
2433: WHERE l_EndDate between effective_start_date and effective_end_date
2434: AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';
2435:
2436: hr_utility.set_location('py_za_tx_utl_01082000.TrvAll',19);