[Home] [Help]
181: pdb.defined_balance_id def_id
182: FROM pay_element_types_f pet
183: ,per_all_assignments_f paa
184: ,pay_balance_types pbt
185: ,pay_defined_balances pdb
186: ,pay_balance_dimensions pbd
187: -- ,per_periods_of_service pps
188: ,pay_payroll_actions ppa
189: ,pay_assignment_actions pac
254: is
255: select nvl(pbt.reporting_name,pbt.balance_name) balance_name, /* Bug 5743196 -Added nvl */
256: pdb.defined_balance_id
257: from pay_balance_types pbt
258: ,pay_defined_balances pdb
259: ,pay_balance_dimensions pbd
260: where pbt.balance_type_id = c_balance_type_id
261: and pdb.balance_type_id = pbt.balance_type_id
262: and pdb.balance_dimension_id = pbd.balance_dimension_id
585:
586: IS
587: select pay_balance_pkg.get_value(pdb.defined_balance_id, v_assignment_action_id, c_registered_employer,null,null,null,null) --2610141
588: FROM pay_balance_types pbt,
589: pay_defined_balances pdb,
590: pay_balance_dimensions pbd
591: WHERE pbt.legislation_code = 'AU'
592: AND pbt.balance_name = 'Lump Sum E Payments'
593: AND pbt.balance_type_id = pdb.balance_type_id
745: /* Bug#3004966 - Added two Balances 'Termination Deductions', 'Total_Tax_Deductions'*/
746: CURSOR c_bal_id (c_dimension_name pay_balance_dimensions.dimension_name%TYPE) IS
747: SELECT pbt.balance_name,pbt.balance_type_id,pdb.defined_balance_id
748: from pay_balance_types pbt,
749: pay_defined_balances pdb, --Bug# 3193479
750: pay_balance_dimensions pbd
751: where pbt.legislation_code = 'AU'
752: and pbt.balance_name in
753: ('CDEP','Earnings_Total','Lump Sum A Deductions',
765:
766: i number;
767: l_bal_name pay_balance_types.balance_name%type;
768: l_bal_id pay_balance_types.balance_type_id%type;
769: l_def_bal_id pay_defined_balances.defined_balance_id%TYPE; --Bug# 3193479
770: c_dimension_name pay_balance_dimensions.dimension_name%TYPE; -- Bug: 3186840
771: g_debug boolean;
772:
773: Cursor c_fbt_balance IS --Bug#3749530
772:
773: Cursor c_fbt_balance IS --Bug#3749530
774: select pdb.defined_balance_id
775: from pay_balance_types pbt,
776: pay_defined_balances pdb,
777: pay_balance_dimensions pbd
778: where pbt.balance_name ='Fringe Benefits'
779: and pbt.balance_type_id = pdb.balance_type_id
780: and pdb.balance_dimension_id = pbd.balance_dimension_id
1053: return g_etp_tax;
1054: end etp_tax;
1055:
1056: --------------------Bug# 3193479-----------------------------------------------------------------
1057: function get_bal_value_new(p_defined_balance_id pay_defined_balances.defined_balance_id%TYPE)
1058: return number is
1059: begin
1060: for i in 1..g_result_table.last
1061: loop
1327: 'CDEP',10,'Other Income',11
1328: ,'Workplace Giving Deductions', 12) sort_index /*4015082 */
1329: , pdb.defined_balance_id
1330: FROM pay_balance_types pbt
1331: , pay_defined_balances pdb
1332: , pay_balance_dimensions pbd
1333: WHERE pbt.legislation_code = 'AU'
1334: AND pbt.balance_name in
1335: ('Lump Sum A Payments','Lump Sum B Payments','Lump Sum D Payments',
1343: AND pbd.dimension_name = p_dimension_name
1344: ORDER BY sort_index;
1345:
1346: l_sort_index number;
1347: l_def_bal_id pay_defined_balances.defined_balance_id%TYPE;
1348:
1349: BEGIN
1350:
1351: g_debug := hr_utility.debug_enabled;
1967:
1968: Cursor c_fbt_balance is
1969: select pdb.defined_balance_id
1970: from pay_balance_types pbt,
1971: pay_defined_balances pdb,
1972: pay_balance_dimensions pbd
1973: where pbt.balance_name ='Fringe Benefits'
1974: and pbt.balance_type_id = pdb.balance_type_id
1975: and pdb.balance_dimension_id = pbd.balance_dimension_id