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 ,
688: TO_NUMBER(hsck.segment1) ,
689: pap.full_name ,
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
705: AND pap.person_type_id = ppt.person_Type_id
706: AND ppt.system_person_type = 'EMP'
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
771: AND pap.person_type_id = ppt.person_Type_id
772: AND ppt.system_person_type = 'EMP'
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
838: AND pap.person_type_id = ppt.person_Type_id
839: AND ppt.system_person_type = 'EMP'