APPS.PAY_IN_TERM_RPRT_GEN_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 404: ,pay_element_types_f pet

400: ,pec.classification_name classification
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

Line 617: ,pay_element_types_f pet

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

Line 673: ,pay_element_types_f pet

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

Line 729: ,pay_element_types_f pet

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

Line 785: ,pay_element_types_f pet

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

Line 837: ,pay_element_types_f pet

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

Line 886: ,pay_element_types_f pet

882: ,nvl(pet.reporting_name, pet.element_name) description
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

Line 918: ,pay_element_types_f petf

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

Line 949: ,pay_element_types_f pet

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