APPS.PY_ZA_TX_UTL_01032000 dependencies on FF_GLOBALS_F

Line 161: (p_GlbNme ff_globals_f.global_name%TYPE

157: -- Tax Utility Functions
158: --
159:
160: FUNCTION GlbVal
161: (p_GlbNme ff_globals_f.global_name%TYPE
162: ,p_EffDte DATE
163: ) RETURN ff_globals_f.global_value%TYPE
164: AS
165: -- Variables

Line 163: ) RETURN ff_globals_f.global_value%TYPE

159:
160: FUNCTION GlbVal
161: (p_GlbNme ff_globals_f.global_name%TYPE
162: ,p_EffDte DATE
163: ) RETURN ff_globals_f.global_value%TYPE
164: AS
165: -- Variables
166: l_GlbVal NUMBER(15,2);
167: BEGIN

Line 174: FROM ff_globals_f

170: WriteHrTrace('p_EffDte :'||to_char(p_EffDte,'DD/MM/YYYY'));
171: --
172: SELECT TO_NUMBER(global_value)
173: INTO l_GlbVal
174: FROM ff_globals_f
175: WHERE p_EffDte between effective_start_date and effective_end_date
176: AND global_name = p_GlbNme;
177:
178: hr_utility.set_location('py_za_tx_utl_01032000.GlbVal',2);

Line 1471: FROM ff_globals_f

1467: )
1468: IS
1469: SELECT effective_end_date
1470: , to_number(global_value) global_value
1471: FROM ff_globals_f
1472: WHERE effective_end_date < p_ty_ed
1473: AND effective_end_date > p_ty_sd
1474: AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';
1475:

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

1488: l_CurRfiYtd NUMBER(15,2) DEFAULT 0;
1489: l_TotRfiYtd NUMBER(15,2) DEFAULT 0;
1490: l_CurTxbRfi NUMBER(15,2) DEFAULT 0;
1491: l_TotTxbRfi NUMBER(15,2) DEFAULT 0;
1492: l_GlbVal ff_globals_f.global_value%TYPE DEFAULT '0';
1493:
1494: BEGIN
1495: hr_utility.set_location('py_za_tx_utl_01032000.TrvAll',1);
1496: -- Retrieve Balance Type ID's

Line 1678: FROM ff_globals_f

1674: l_RfiYtd := py_za_tx_01032000.bal_TA_RFI_PTD;
1675: -- Global Value
1676: SELECT TO_NUMBER(global_value)
1677: INTO l_GlbVal
1678: FROM ff_globals_f
1679: WHERE l_EndDate between effective_start_date and effective_end_date
1680: AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';
1681:
1682: hr_utility.set_location('py_za_tx_utl_01032000.TrvAll',17);

Line 1693: FROM ff_globals_f

1689:
1690: -- Global Value
1691: SELECT TO_NUMBER(global_value)
1692: INTO l_GlbVal
1693: FROM ff_globals_f
1694: WHERE l_EndDate between effective_start_date and effective_end_date
1695: AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';
1696:
1697: hr_utility.set_location('py_za_tx_utl_01032000.TrvAll',19);