APPS.PY_ZA_TX_UTL_01032002 dependencies on PAY_BALANCE_TYPES

Line 2104: l_NrfiBalID pay_balance_types.balance_type_id%TYPE;

2100: AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';
2101:
2102: -- Variables
2103: --
2104: l_NrfiBalID pay_balance_types.balance_type_id%TYPE;
2105: l_RfiBalID pay_balance_types.balance_type_id%TYPE;
2106: l_StrtDate DATE;
2107: l_EndDate DATE;
2108: l_NrfiYtd t_balance DEFAULT 0;

Line 2105: l_RfiBalID pay_balance_types.balance_type_id%TYPE;

2101:
2102: -- Variables
2103: --
2104: l_NrfiBalID pay_balance_types.balance_type_id%TYPE;
2105: l_RfiBalID pay_balance_types.balance_type_id%TYPE;
2106: l_StrtDate DATE;
2107: l_EndDate DATE;
2108: l_NrfiYtd t_balance DEFAULT 0;
2109: l_CurNrfiYtd t_balance DEFAULT 0;

Line 2125: FROM pay_balance_types

2121: hr_utility.set_location('py_za_tx_utl_01032002.TrvAll',1);
2122: -- Retrieve Balance Type ID's
2123: SELECT balance_type_id
2124: INTO l_NrfiBalID
2125: FROM pay_balance_types
2126: WHERE legislation_code = 'ZA'
2127: AND balance_name = 'Travel Allowance NRFI';
2128:
2129: hr_utility.set_location('py_za_tx_utl_01032002.TrvAll',2);

Line 2133: FROM pay_balance_types

2129: hr_utility.set_location('py_za_tx_utl_01032002.TrvAll',2);
2130:
2131: SELECT balance_type_id
2132: INTO l_RfiBalID
2133: FROM pay_balance_types
2134: WHERE legislation_code = 'ZA'
2135: AND balance_name = 'Travel Allowance RFI';
2136:
2137: -- Check Calc and setup correct values