APPS.PAY_US_DEF_COMP_457 dependencies on PAY_ELEMENT_TYPES_F

Line 682: SELECT /*+ INDEX (pet pay_element_types_f_pk)

678:
679: IF (p_person_id IS NULL) THEN
680:
681: OPEN C_All_Emp FOR
682: SELECT /*+ INDEX (pet pay_element_types_f_pk)
683: INDEX (pel pay_element_links_f_n7)
684: INDEX (ppt per_person_types_pk)
685: INDEX (hsck HR_SOFT_CODING_KEYFLEX_PK)
686: USE_NL(hsck) */

Line 700: pay_element_types_f pet,

696: FROM per_assignments_f paa,
697: per_all_people_f pap,
698: pay_element_entries_f pee,
699: pay_element_links_f pel,
700: pay_element_types_f pet,
701: per_person_types ppt,
702: hr_soft_coding_keyflex hsck
703: WHERE paa.assignment_Type = 'E'
704: AND pap.person_id = paa.person_id

Line 766: pay_element_types_f pet,

762: FROM per_assignments_f paa,
763: per_all_people_f pap,
764: pay_element_entries_f pee,
765: pay_element_links_f pel,
766: pay_element_types_f pet,
767: per_person_types ppt,
768: hr_soft_coding_keyflex hsck
769: WHERE paa.assignment_Type = 'E'
770: AND pap.person_id = paa.person_id

Line 833: pay_element_types_f pet,

829: FROM per_assignments_f paa,
830: per_all_people_f pap,
831: pay_element_entries_f pee,
832: pay_element_links_f pel,
833: pay_element_types_f pet,
834: per_person_types ppt,
835: hr_soft_coding_keyflex hsck
836: WHERE paa.assignment_Type = 'E'
837: AND pap.person_id = paa.person_id