APPS.PY_ZA_TX_UTL_01032011 dependencies on PAY_BALANCE_TYPES

Line 2856: l_RfiBalID pay_balance_types.balance_type_id%TYPE;

2852: AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';
2853:
2854: -- Variables
2855: --
2856: l_RfiBalID pay_balance_types.balance_type_id%TYPE;
2857: l_StrtDate DATE;
2858: l_EndDate DATE;
2859: l_RfiYtd t_balance DEFAULT 0;
2860: l_CurRfiYtd t_balance DEFAULT 0;

Line 2872: FROM pay_balance_types

2868: -- Retrieve Balance Type ID's
2869:
2870: SELECT balance_type_id
2871: INTO l_RfiBalID
2872: FROM pay_balance_types
2873: WHERE legislation_code = 'ZA'
2874: AND balance_name = 'ZATax Total Taxable Travel Allowance';
2875:
2876: -- Check Calc and setup correct values