[Home] [Help]
152: pdb.defined_balance_id defined_balance_id,
153: pbt.balance_name
154: FROM pay_balance_types pbt,
155: pay_balance_dimensions pbd,
156: pay_defined_balances pdb
157: WHERE pbt.balance_name IN ('Earnings_Total','Direct Payments','Termination_Payments','Involuntary Deductions',
158: 'Pre Tax Deductions','Termination Deductions','Voluntary Deductions','Total_Tax_Deductions',
159: 'Earnings_Non_Taxable','Employer_Charges','Lump Sum A Payments','Lump Sum B Payments','Lump Sum C Payments',
160: 'Lump Sum D Payments','Lump Sum E Payments','Invalidity Payments','CDEP','Leave Payments Marginal','Other Income','Union Fees', 'Workplace Giving Deductions') /*4085496 */
184:
185: Cursor c_fbt_balance is
186: select pdb.defined_balance_id
187: from pay_balance_types pbt,
188: pay_defined_balances pdb,
189: pay_balance_dimensions pbd
190: where pbt.balance_name ='Fringe Benefits'
191: and pbt.balance_type_id = pdb.balance_type_id
192: and pdb.balance_dimension_id = pbd.balance_dimension_id /* Bug 2501105 */
442: ,c_lst_fbt_yr_start date
443: ,c_fbt_year_start date
444: ,c_fbt_year_end date
445: ,c_lst_year_start date
446: ,c_fbt_defined_balance_id pay_defined_balances.defined_balance_id%type
447: ,c_assignment_id varchar2
448: ) is
449: SELECT /*+ INDEX(pap per_people_f_pk)
450: INDEX(paa per_assignments_f_fk1)
516: ,c_lst_fbt_yr_start date
517: ,c_fbt_year_start date
518: ,c_fbt_year_end date
519: ,c_lst_year_start date
520: ,c_fbt_defined_balance_id pay_defined_balances.defined_balance_id%type
521: ,c_assignment_id varchar2
522: ) is
523: SELECT /*+ INDEX(pap per_people_f_pk)
524: INDEX(paa per_assignments_f_fk1)
593: ,c_lst_fbt_yr_start date
594: ,c_fbt_year_start date
595: ,c_fbt_year_end date
596: ,c_lst_year_start date
597: ,c_fbt_defined_balance_id pay_defined_balances.defined_balance_id%type
598: ,c_assignment_id varchar2
599: )
600: IS
601: SELECT /*+ INDEX(pap per_people_f_pk)
651:
652: Cursor c_fbt_balance is
653: select pdb.defined_balance_id
654: from pay_balance_types pbt,
655: pay_defined_balances pdb,
656: pay_balance_dimensions pbd
657: where pbt.balance_name ='Fringe Benefits'
658: and pbt.balance_type_id = pdb.balance_type_id
659: and pdb.balance_dimension_id = pbd.balance_dimension_id /* Bug 2501105 */
1850: c_assignment_action_id,
1851: c_tax_unit_id,
1852: null,null,null,null)) --2610141
1853: FROM pay_balance_types pbt,
1854: pay_defined_balances pdb,
1855: pay_balance_dimensions pbd
1856: WHERE pbt.legislation_code = 'AU'
1857: AND pbt.balance_name = 'Lump Sum E Payments'
1858: AND pbt.balance_type_id = pdb.balance_type_id
1950: is
1951: select nvl(pbt.reporting_name,pbt.balance_name) balance_name, /* Bug 5743196 added nvl */
1952: pdb.defined_balance_id
1953: from pay_balance_types pbt
1954: ,pay_defined_balances pdb
1955: ,pay_balance_dimensions pbd
1956: where pbt.balance_type_id = c_balance_type_id
1957: and pdb.balance_type_id = pbt.balance_type_id
1958: and pdb.balance_dimension_id = pbd.balance_dimension_id