APPS.PY_ZA_TX_UTL_01032007 dependencies on PAY_BALANCE_TYPES

Line 2288: l_RfiBalID pay_balance_types.balance_type_id%TYPE;

2284: AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';
2285:
2286: -- Variables
2287: --
2288: l_RfiBalID pay_balance_types.balance_type_id%TYPE;
2289: l_StrtDate DATE;
2290: l_EndDate DATE;
2291: l_RfiYtd t_balance DEFAULT 0;
2292: l_CurRfiYtd t_balance DEFAULT 0;

Line 2304: FROM pay_balance_types

2300: -- Retrieve Balance Type ID's
2301:
2302: SELECT balance_type_id
2303: INTO l_RfiBalID
2304: FROM pay_balance_types
2305: WHERE legislation_code = 'ZA'
2306: AND balance_name = 'ZATax Total Taxable Travel Allowance';
2307:
2308: -- Check Calc and setup correct values