[Home] [Help]
401: ,pet.element_name elename
402: FROM per_assignments_f paf
403: ,per_people_f ppf
404: ,pay_element_types_f pet
405: ,pay_input_values_f piv
406: ,pay_assignment_actions paa
407: ,pay_run_results prr
408: ,pay_run_result_values prrv
409: ,per_periods_of_service ppos
614: ,prrv.result_value amount
615: FROM per_assignments_f paf
616: ,per_people_f ppf
617: ,pay_element_types_f pet
618: ,pay_input_values_f piv
619: ,pay_element_entries_f pee
620: ,pay_element_entry_values_f peev
621: ,pay_element_classifications pec
622: ,pay_element_links_f pel
670: ,prrv.result_value amount
671: FROM per_assignments_f paf
672: ,per_people_f ppf
673: ,pay_element_types_f pet
674: ,pay_input_values_f piv
675: ,pay_element_entries_f pee
676: ,pay_element_classifications pec
677: ,pay_element_links_f pel
678: ,pay_assignment_actions paa
726: ,piv.name description
727: FROM per_assignments_f paf
728: ,per_people_f ppf
729: ,pay_element_types_f pet
730: ,pay_input_values_f piv
731: ,pay_assignment_actions paa
732: ,pay_run_results prr
733: ,pay_run_result_values prrv
734: ,per_periods_of_service ppos
782: ,nvl(pet.reporting_name, pet.element_name) Element
783: FROM per_assignments_f paf
784: ,per_people_f ppf
785: ,pay_element_types_f pet
786: ,pay_input_values_f piv
787: ,pay_assignment_actions paa
788: ,pay_run_results prr
789: ,pay_run_result_values prrv
790: ,per_periods_of_service ppos
834: ,nvl(pet.reporting_name, pet.element_name) Element
835: FROM per_assignments_f paf
836: ,per_people_f ppf
837: ,pay_element_types_f pet
838: ,pay_input_values_f piv
839: ,pay_assignment_actions paa
840: ,pay_run_results prr
841: ,pay_run_result_values prrv
842: ,per_periods_of_service ppos
883: ,pet.element_name elename
884: FROM per_assignments_f paf
885: ,per_people_f ppf
886: ,pay_element_types_f pet
887: ,pay_input_values_f piv
888: ,pay_assignment_actions paa
889: ,pay_run_results prr
890: ,pay_run_result_values prrv
891: ,per_periods_of_service ppos
913: ,'Other Termination Payments')
914: AND pet.element_name NOT IN (select petf.element_name
915: from pay_balance_feeds_f pbff
916: ,pay_balance_types pbt
917: ,pay_input_values_f pivf
918: ,pay_element_types_f petf
919: where pbff.balance_type_id = pbt.balance_type_id
920: and pbt.balance_name in ('Retrenchment Compensation'
921: , 'Voluntary Retirement Benefits')
946: SUM(ABS(fnd_number.canonical_to_number(prrv.result_value))) amount
947: FROM per_assignments_f paf
948: ,per_people_f ppf
949: ,pay_element_types_f pet
950: ,pay_input_values_f piv
951: ,pay_assignment_actions paa
952: -- ,pay_element_entries_f peef-- Added as a part of bug fix 4774108
953: ,pay_run_results prr
954: ,pay_run_result_values prrv