APPS.PAY_IN_TERM_RPRT_GEN_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 309: ,pay_element_types_f pet

305: ,sum(prrv.result_value) amount
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

Line 521: ,pay_element_types_f pet

517: ,INITCAP(peev.screen_entry_value) loan_type
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

Line 577: ,pay_element_types_f pet

573: SELECT piv.name description
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

Line 633: ,pay_element_types_f pet

629: SELECT prrv.result_value amount
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

Line 689: ,pay_element_types_f pet

685: ,prrv.result_value amount
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

Line 741: ,pay_element_types_f pet

737: ,prrv.result_value amount
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

Line 789: ,pay_element_types_f pet

785: SELECT sum(prrv.result_value) amount
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

Line 821: ,pay_element_types_f petf

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')
825: and pbff.input_value_id = pivf.input_value_id

Line 852: ,pay_element_types_f pet

848: SELECT /*+ ORDERED */
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