[Home] [Help]
306: ,pec.classification_name classification
307: FROM per_assignments_f paf
308: ,per_people_f ppf
309: ,pay_element_types_f pet
310: ,pay_input_values_f piv
311: ,pay_assignment_actions paa
312: ,pay_run_results prr
313: ,pay_run_result_values prrv
314: ,per_periods_of_service ppos
518: ,prrv.result_value amount
519: FROM per_assignments_f paf
520: ,per_people_f ppf
521: ,pay_element_types_f pet
522: ,pay_input_values_f piv
523: ,pay_element_entries_f pee
524: ,pay_element_entry_values_f peev
525: ,pay_element_classifications pec
526: ,pay_element_links_f pel
574: ,prrv.result_value amount
575: FROM per_assignments_f paf
576: ,per_people_f ppf
577: ,pay_element_types_f pet
578: ,pay_input_values_f piv
579: ,pay_element_entries_f pee
580: ,pay_element_classifications pec
581: ,pay_element_links_f pel
582: ,pay_assignment_actions paa
630: ,piv.name description
631: FROM per_assignments_f paf
632: ,per_people_f ppf
633: ,pay_element_types_f pet
634: ,pay_input_values_f piv
635: ,pay_assignment_actions paa
636: ,pay_run_results prr
637: ,pay_run_result_values prrv
638: ,per_periods_of_service ppos
686: ,nvl(pet.reporting_name, pet.element_name) Element
687: FROM per_assignments_f paf
688: ,per_people_f ppf
689: ,pay_element_types_f pet
690: ,pay_input_values_f piv
691: ,pay_assignment_actions paa
692: ,pay_run_results prr
693: ,pay_run_result_values prrv
694: ,per_periods_of_service ppos
738: ,nvl(pet.reporting_name, pet.element_name) Element
739: FROM per_assignments_f paf
740: ,per_people_f ppf
741: ,pay_element_types_f pet
742: ,pay_input_values_f piv
743: ,pay_assignment_actions paa
744: ,pay_run_results prr
745: ,pay_run_result_values prrv
746: ,per_periods_of_service ppos
786: ,nvl(pet.reporting_name, pet.element_name) description
787: FROM per_assignments_f paf
788: ,per_people_f ppf
789: ,pay_element_types_f pet
790: ,pay_input_values_f piv
791: ,pay_assignment_actions paa
792: ,pay_run_results prr
793: ,pay_run_result_values prrv
794: ,per_periods_of_service ppos
816: ,'Other Termination Payments')
817: AND pet.element_name NOT IN (select petf.element_name
818: from pay_balance_feeds_f pbff
819: ,pay_balance_types pbt
820: ,pay_input_values_f pivf
821: ,pay_element_types_f petf
822: where pbff.balance_type_id = pbt.balance_type_id
823: and pbt.balance_name in ('Retrenchment Compensation'
824: , 'Voluntary Retirement Benefits')
849: SUM(ABS(fnd_number.canonical_to_number(prrv.result_value))) amount
850: FROM per_assignments_f paf
851: ,per_people_f ppf
852: ,pay_element_types_f pet
853: ,pay_input_values_f piv
854: ,pay_assignment_actions paa
855: -- ,pay_element_entries_f peef-- Added as a part of bug fix 4774108
856: ,pay_run_results prr
857: ,pay_run_result_values prrv