APPS.PAY_AU_SGC_PKG dependencies on PAY_DEFINED_BALANCES

Line 58: pay_defined_balances pdb

54: is
55: select pdb.defined_balance_id
56: FROM pay_balance_types pbt,
57: pay_balance_dimensions pbd,
58: pay_defined_balances pdb
59: where pbt.balance_name='Super_Guarantee'
60: AND pbt.legislation_code=c_legislation_code
61: AND pbd.database_item_suffix = c_dimension_name
62: AND pbt.balance_type_id = pdb.balance_type_id

Line 162: l_super_guarantee_bal_id_qtd pay_defined_balances.defined_balance_id%type; --2610141

158: l_bal_id_mtd pay_balance_types.balance_type_id%type; --2610141
159: l_salary number;
160: l_bal_id_min_superable_sal pay_balance_types.balance_type_id%type;
161: l_assignment_action_id pay_assignment_actions.assignment_action_id%type; --2610141
162: l_super_guarantee_bal_id_qtd pay_defined_balances.defined_balance_id%type; --2610141
163:
164:
165:
166: begin

Line 331: l_super_guarantee_bal_id_qtd pay_defined_balances.defined_balance_id%type; --2610141

327: l_bal_id_mtd pay_balance_types.balance_type_id%type; --2610141
328: l_salary number;
329: l_bal_id_min_superable_sal pay_balance_types.balance_type_id%type;
330: l_assignment_action_id pay_assignment_actions.assignment_action_id%type; --2610141
331: l_super_guarantee_bal_id_qtd pay_defined_balances.defined_balance_id%type; --2610141
332:
333:
334: begin
335: hr_utility.set_location(' Entering : employee_super_details',3);