DBA Data[Home] [Help]

APPS.PAY_US_DEF_COMP_457 dependencies on HR_SOFT_CODING_KEYFLEX

Line 685: INDEX (hsck HR_SOFT_CODING_KEYFLEX_PK)

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 ,

Line 702: hr_soft_coding_keyflex hsck

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'

Line 768: hr_soft_coding_keyflex hsck

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'

Line 835: hr_soft_coding_keyflex hsck

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'