APPS.PAY_US_DEF_COMP_457 dependencies on PAY_ELEMENT_LINKS_F

Line 683: INDEX (pel pay_element_links_f_n7)

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) */
687: DISTINCT paa.person_id ,

Line 699: pay_element_links_f pel,

695: TO_CHAR(MAX(paa.effective_end_date), 'DD/MM/YYYY')
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'

Line 765: pay_element_links_f pel,

761: TO_CHAR(MAX(paa.effective_end_date), 'DD/MM/YYYY')
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'

Line 832: pay_element_links_f pel,

828: TO_CHAR(MAX(paa.effective_end_date), 'DD/MM/YYYY')
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'