APPS.PY_ZA_TX_UTL_01032009 dependencies on PAY_BALANCE_TYPES

Line 2841: l_RfiBalID pay_balance_types.balance_type_id%TYPE;

2837: AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';
2838:
2839: -- Variables
2840: --
2841: l_RfiBalID pay_balance_types.balance_type_id%TYPE;
2842: l_StrtDate DATE;
2843: l_EndDate DATE;
2844: l_RfiYtd t_balance DEFAULT 0;
2845: l_CurRfiYtd t_balance DEFAULT 0;

Line 2857: FROM pay_balance_types

2853: -- Retrieve Balance Type ID's
2854:
2855: SELECT balance_type_id
2856: INTO l_RfiBalID
2857: FROM pay_balance_types
2858: WHERE legislation_code = 'ZA'
2859: AND balance_name = 'ZATax Total Taxable Travel Allowance';
2860:
2861: -- Check Calc and setup correct values