APPS.PY_ZA_TX_UTL_01032004 dependencies on FF_GLOBALS_F

Line 190: (p_GlbNme ff_globals_f.global_name%TYPE

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

Line 192: ) RETURN ff_globals_f.global_value%TYPE

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

Line 203: FROM ff_globals_f

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

Line 2611: FROM ff_globals_f

2607: )
2608: IS
2609: SELECT effective_end_date
2610: , to_number(global_value) global_value
2611: FROM ff_globals_f
2612: WHERE effective_end_date < p_ty_ed
2613: AND effective_end_date > p_ty_sd
2614: AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';
2615:

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

2628: l_CurRfiYtd t_balance DEFAULT 0;
2629: l_TotRfiYtd t_balance DEFAULT 0;
2630: l_CurTxbRfi t_balance DEFAULT 0;
2631: l_TotTxbRfi t_balance DEFAULT 0;
2632: l_GlbVal ff_globals_f.global_value%TYPE DEFAULT '0';
2633:
2634: BEGIN
2635: hr_utility.set_location('py_za_tx_utl_01032004.TrvAll',1);
2636: -- Retrieve Balance Type ID's

Line 2817: FROM ff_globals_f

2813: l_RfiYtd := py_za_tx_01032004.bal_TA_RFI_PTD;
2814: -- Global Value
2815: SELECT TO_NUMBER(global_value)
2816: INTO l_GlbVal
2817: FROM ff_globals_f
2818: WHERE l_EndDate between effective_start_date
2819: and effective_end_date
2820: AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';
2821:

Line 2833: FROM ff_globals_f

2829:
2830: -- Global Value
2831: SELECT TO_NUMBER(global_value)
2832: INTO l_GlbVal
2833: FROM ff_globals_f
2834: WHERE l_EndDate between effective_start_date
2835: and effective_end_date
2836: AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';
2837: