APPS.PY_ZA_TX_UTL_01032013 dependencies on PAY_BALANCE_TYPES

Line 2962: l_RfiBalID pay_balance_types.balance_type_id%TYPE;

2958: AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';
2959:
2960: -- Variables
2961: --
2962: l_RfiBalID pay_balance_types.balance_type_id%TYPE;
2963: l_StrtDate DATE;
2964: l_EndDate DATE;
2965: l_RfiYtd t_balance DEFAULT 0;
2966: l_CurRfiYtd t_balance DEFAULT 0;

Line 2978: FROM pay_balance_types

2974: -- Retrieve Balance Type ID's
2975:
2976: SELECT balance_type_id
2977: INTO l_RfiBalID
2978: FROM pay_balance_types
2979: WHERE legislation_code = 'ZA'
2980: AND balance_name = 'ZATax Total Taxable Travel Allowance';
2981:
2982: -- Check Calc and setup correct values