[Home] [Help]
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
190: ,pay_run_results prr
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
263: and pbd.dimension_name = '_ASG_LE_YTD'
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
594: AND pbd.balance_dimension_id = pdb.balance_dimension_id
742: p_lst_yr_term VARCHAR2 DEFAULT NULL ) return number
743: is
744:
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
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',
754: 'Lump Sum A Payments','Lump Sum B Deductions','Lump Sum B Payments',
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
774: select pdb.defined_balance_id
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
781: and pbd.legislation_code ='AU'
1316: end populate_exclusion_table;
1317:
1318: /* Start of Bug : 3186840 */
1319:
1320: PROCEDURE populate_group_def_bal_ids(p_dimension_name pay_balance_dimensions.dimension_name%TYPE)
1321: IS
1322:
1323: CURSOR csr_group_def_bal_ids IS
1324: SELECT decode(pbt.balance_name,'Lump Sum A Payments',1,'Lump Sum B Payments',2,
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',
1336: 'Union Fees','Lump Sum C Deductions','Termination Deductions',
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
1976: and pbd.legislation_code ='AU'