APPS.PY_ZA_TX_UTL_01032012 dependencies on PAY_BALANCE_TYPES

Line 2901: l_RfiBalID pay_balance_types.balance_type_id%TYPE;

2897: AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';
2898:
2899: -- Variables
2900: --
2901: l_RfiBalID pay_balance_types.balance_type_id%TYPE;
2902: l_StrtDate DATE;
2903: l_EndDate DATE;
2904: l_RfiYtd t_balance DEFAULT 0;
2905: l_CurRfiYtd t_balance DEFAULT 0;

Line 2917: FROM pay_balance_types

2913: -- Retrieve Balance Type ID's
2914:
2915: SELECT balance_type_id
2916: INTO l_RfiBalID
2917: FROM pay_balance_types
2918: WHERE legislation_code = 'ZA'
2919: AND balance_name = 'ZATax Total Taxable Travel Allowance';
2920:
2921: -- Check Calc and setup correct values