[Home] [Help]
290: pdb.defined_balance_id defined_balance_id,
291: pbt.balance_name
292: FROM pay_balance_types pbt,
293: pay_balance_dimensions pbd,
294: pay_defined_balances pdb
295: WHERE pbt.balance_name IN ('Earnings_Total','Direct Payments','Termination_Payments','Involuntary Deductions',
296: 'Pre Tax Deductions','Termination Deductions','Voluntary Deductions','Total_Tax_Deductions',
297: 'Earnings_Non_Taxable','Employer_Charges','Lump Sum A Payments','Lump Sum B Payments','Lump Sum C Payments',
298: 'Lump Sum D Payments','Lump Sum E Payments','Invalidity Payments','CDEP','Leave Payments Marginal',
319: ,'Retro Earnings Additional GT 12 Mths Amount', 5 -- bug 13362286
320: ) sort_index
321: , pdb.defined_balance_id defined_balance_id
322: FROM pay_balance_types pbt,
323: pay_defined_balances pdb,
324: pay_balance_dimensions pbd
325: WHERE pbt.legislation_code = 'AU'
326: AND pbt.balance_name in ( 'Lump Sum E Payments'
327: ,'Retro Earnings Leave Loading GT 12 Mths Amount'
353:
354: Cursor c_fbt_balance is
355: select pdb.defined_balance_id
356: from pay_balance_types pbt,
357: pay_defined_balances pdb,
358: pay_balance_dimensions pbd
359: where pbt.balance_name ='Fringe Benefits'
360: and pbt.balance_type_id = pdb.balance_type_id
361: and pdb.balance_dimension_id = pbd.balance_dimension_id /* Bug 2501105 */
789: ,c_lst_fbt_yr_start date
790: ,c_fbt_year_start date
791: ,c_fbt_year_end date
792: ,c_lst_year_start date
793: ,c_fbt_defined_balance_id pay_defined_balances.defined_balance_id%type
794: ,c_assignment_id varchar2
795: ) is
796: SELECT /*+ INDEX(pap per_people_f_pk)
797: INDEX(paa per_assignments_f_fk1)
872: ,c_lst_fbt_yr_start date
873: ,c_fbt_year_start date
874: ,c_fbt_year_end date
875: ,c_lst_year_start date
876: ,c_fbt_defined_balance_id pay_defined_balances.defined_balance_id%type
877: ,c_assignment_id varchar2
878: ) is
879: SELECT /*+ INDEX(pap per_people_f_pk)
880: INDEX(paa per_assignments_f_fk1)
958: ,c_lst_fbt_yr_start date
959: ,c_fbt_year_start date
960: ,c_fbt_year_end date
961: ,c_lst_year_start date
962: ,c_fbt_defined_balance_id pay_defined_balances.defined_balance_id%type
963: ,c_assignment_id varchar2
964: )
965: IS
966: SELECT paa.assignment_id
1025:
1026: Cursor c_fbt_balance is
1027: select pdb.defined_balance_id
1028: from pay_balance_types pbt,
1029: pay_defined_balances pdb,
1030: pay_balance_dimensions pbd
1031: where pbt.balance_name ='Fringe Benefits'
1032: and pbt.balance_type_id = pdb.balance_type_id
1033: and pdb.balance_dimension_id = pbd.balance_dimension_id /* Bug 2501105 */
1435: and nvl(aei_information2,c_tax_unit_id) = decode(aei_information2,'-999',aei_information2,c_tax_unit_id)
1436: and pae.aei_information1 = hr.lookup_code
1437: and hr.lookup_type = 'AU_PS_FINANCIAL_YEAR';
1438:
1439: cursor get_balance_name (c_defined_balance_id pay_defined_balances.defined_balance_id%type) is
1440: select NVL(pbt.reporting_name,pbt.balance_name) balance_name
1441: from pay_defined_balances pdb,
1442: pay_balance_types pbt
1443: where pdb.defined_balance_id = c_defined_balance_id
1437: and hr.lookup_type = 'AU_PS_FINANCIAL_YEAR';
1438:
1439: cursor get_balance_name (c_defined_balance_id pay_defined_balances.defined_balance_id%type) is
1440: select NVL(pbt.reporting_name,pbt.balance_name) balance_name
1441: from pay_defined_balances pdb,
1442: pay_balance_types pbt
1443: where pdb.defined_balance_id = c_defined_balance_id
1444: and pdb.balance_type_id = pbt.balance_type_id
1445: and pdb.business_group_id = g_business_group_id;
2562: (
2563: select 1
2564: from
2565: PAY_BALANCE_ATTRIBUTES pba
2566: ,pay_defined_balances pdb
2567: ,pay_balance_dimensions pbd
2568: ,PAY_BALANCE_FEEDS_F pbf
2569: where pba.attribute_id = g_attribute_id
2570: AND pba.defined_balance_id = pdb.defined_balance_id
2605: ,pay_element_types_f pet
2606: ,pay_input_values_f piv
2607: ,pay_run_result_values prrv
2608: ,pay_balance_feeds_f pbf
2609: ,pay_defined_balances pdb
2610: ,pay_balance_dimensions pbd
2611: , pay_balance_attributes pba
2612: WHERE pba.attribute_id = g_attribute_id
2613: AND pdb.defined_balance_id = pba.defined_balance_id
2973: ,p_run_assignment_action_id
2974: ,g_tax_unit_id
2975: ,NULL,NULL,NULL,NULL,NULL,NULL,NULL) balance_value
2976: FROM pay_balance_attributes pba
2977: ,pay_defined_balances pdb
2978: ,pay_balance_types pbt
2979: ,pay_balance_dimensions pbd
2980: WHERE pba.attribute_id = g_attribute_id
2981: AND pdb.defined_balance_id = pba.defined_balance_id
2993: select pbt.balance_type_id,
2994: pbt.balance_name
2995: from pay_bal_attribute_definitions pbad
2996: ,pay_balance_attributes pba
2997: ,pay_defined_balances pdb
2998: ,pay_balance_types pbt
2999: ,pay_balance_dimensions pbd
3000: where pbad.attribute_name = 'AU_EOY_ALLOWANCE'
3001: and pba.attribute_id = pbad.attribute_id
3005: and pbd.balance_dimension_id = pdb.balance_dimension_id
3006: and pbd.dimension_name = '_ASG_LE_YTD'
3007: and pbd.legislation_code = 'AU';
3008:
3009: cursor get_balance_name (c_defined_balance_id pay_defined_balances.defined_balance_id%type) is
3010: select NVL(pbt.reporting_name,pbt.balance_name) balance_name
3011: from pay_defined_balances pdb,
3012: pay_balance_types pbt
3013: where pdb.defined_balance_id = c_defined_balance_id
3007: and pbd.legislation_code = 'AU';
3008:
3009: cursor get_balance_name (c_defined_balance_id pay_defined_balances.defined_balance_id%type) is
3010: select NVL(pbt.reporting_name,pbt.balance_name) balance_name
3011: from pay_defined_balances pdb,
3012: pay_balance_types pbt
3013: where pdb.defined_balance_id = c_defined_balance_id
3014: and pdb.balance_type_id = pbt.balance_type_id
3015: and pdb.business_group_id = g_business_group_id;