APPS.PY_ZA_TX_UTL_01082000 dependencies on PAY_BALANCE_TYPES

Line 2217: l_NrfiBalID pay_balance_types.balance_type_id%TYPE;

2213: AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';
2214:
2215: -- Variables
2216: --
2217: l_NrfiBalID pay_balance_types.balance_type_id%TYPE;
2218: l_RfiBalID pay_balance_types.balance_type_id%TYPE;
2219: l_StrtDate DATE;
2220: l_EndDate DATE;
2221: l_NrfiYtd NUMBER(15,2) DEFAULT 0;

Line 2218: l_RfiBalID pay_balance_types.balance_type_id%TYPE;

2214:
2215: -- Variables
2216: --
2217: l_NrfiBalID pay_balance_types.balance_type_id%TYPE;
2218: l_RfiBalID pay_balance_types.balance_type_id%TYPE;
2219: l_StrtDate DATE;
2220: l_EndDate DATE;
2221: l_NrfiYtd NUMBER(15,2) DEFAULT 0;
2222: l_CurNrfiYtd NUMBER(15,2) DEFAULT 0;

Line 2238: FROM pay_balance_types

2234: hr_utility.set_location('py_za_tx_utl_01082000.TrvAll',1);
2235: -- Retrieve Balance Type ID's
2236: SELECT balance_type_id
2237: INTO l_NrfiBalID
2238: FROM pay_balance_types
2239: WHERE legislation_code = 'ZA'
2240: AND balance_name = 'Travel Allowance NRFI';
2241:
2242: hr_utility.set_location('py_za_tx_utl_01082000.TrvAll',2);

Line 2246: FROM pay_balance_types

2242: hr_utility.set_location('py_za_tx_utl_01082000.TrvAll',2);
2243:
2244: SELECT balance_type_id
2245: INTO l_RfiBalID
2246: FROM pay_balance_types
2247: WHERE legislation_code = 'ZA'
2248: AND balance_name = 'Travel Allowance RFI';
2249:
2250: -- Check Calc and setup correct values