eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_DEF_COMP_457 dependencies on PER_PERSON_TYPES

Line 148: per_person_types ppt

144: -- EE
145: SELECT full_name
146: INTO l_full_name
147: FROM per_people_f ppf,
148: per_person_types ppt
149: WHERE ppf.person_id = l_person_id
150: AND ppf.effective_start_date =
151: (SELECT MAX(a.effective_start_date)
152: FROM per_people_f a,

Line 153: per_person_types b

149: WHERE ppf.person_id = l_person_id
150: AND ppf.effective_start_date =
151: (SELECT MAX(a.effective_start_date)
152: FROM per_people_f a,
153: per_person_types b
154: WHERE TO_NUMBER(TO_CHAR(a.effective_start_date,'YYYY'))
155: <= p_year
156: AND TO_NUMBER(TO_CHAR(a.effective_end_date,'YYYY'))
157: >= p_year

Line 684: INDEX (ppt per_person_types_pk)

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 ,
688: TO_NUMBER(hsck.segment1) ,

Line 701: per_person_types ppt,

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
705: AND pap.person_type_id = ppt.person_Type_id

Line 728: per_person_types b

724: AND TO_NUMBER(hsck.segment1) = p_gre_id
725: AND pap.effective_start_date =
726: (SELECT MAX(effective_start_date)
727: FROM per_all_people_f a,
728: per_person_types b
729: WHERE a.person_type_id = b.person_type_id
730: AND a.person_id = pap.person_id
731: AND a.business_group_id = pap.business_group_id
732: AND (TO_NUMBER(TO_CHAR(pap.effective_start_date,'YYYY'))

Line 767: per_person_types ppt,

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
771: AND pap.person_type_id = ppt.person_Type_id

Line 794: per_person_types b

790: AND paa.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
791: AND pap.effective_start_date =
792: (SELECT MAX(effective_start_date)
793: FROM per_all_people_f a,
794: per_person_types b
795: WHERE a.person_type_id = b.person_type_id
796: AND a.person_id = pap.person_id
797: AND a.business_group_id = pap.business_group_id
798: AND (TO_NUMBER(TO_CHAR(pap.effective_start_date,'YYYY'))

Line 834: per_person_types ppt,

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
838: AND pap.person_type_id = ppt.person_Type_id

Line 862: per_person_types b

858: AND TO_NUMBER(hsck.segment1) = p_gre_id
859: AND pap.effective_start_date =
860: (SELECT MAX(effective_start_date)
861: FROM per_all_people_f a,
862: per_person_types b
863: WHERE a.person_type_id = b.person_type_id
864: AND a.person_id = pap.person_id
865: AND a.business_group_id = pap.business_group_id
866: AND (TO_NUMBER(TO_CHAR(pap.effective_start_date,'YYYY'))