APPS.PY_ZA_TX_UTL_01032005 dependencies on PAY_BALANCE_TYPES

Line 2158: l_RfiBalID pay_balance_types.balance_type_id%TYPE;

2154: AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';
2155:
2156: -- Variables
2157: --
2158: l_RfiBalID pay_balance_types.balance_type_id%TYPE;
2159: l_StrtDate DATE;
2160: l_EndDate DATE;
2161: l_RfiYtd t_balance DEFAULT 0;
2162: l_CurRfiYtd t_balance DEFAULT 0;

Line 2174: FROM pay_balance_types

2170: -- Retrieve Balance Type ID's
2171:
2172: SELECT balance_type_id
2173: INTO l_RfiBalID
2174: FROM pay_balance_types
2175: WHERE legislation_code = 'ZA'
2176: AND balance_name = 'ZATax Total Taxable Travel Allowance';
2177:
2178: -- Check Calc and setup correct values