DBA Data[Home] [Help]

APPS.HXC_TIMEKEEPER_PROCESS dependencies on PER_PERSON_TYPES

Line 82: per_person_types ppt

78: hxc_tk_group_query_criteria htgqc,
79: per_all_people_f ppf,
80: per_all_assignments_f paa,
81: per_person_type_usages_f ptu,
82: per_person_types ppt
83: WHERE ppf.person_id = paa.person_id
84: AND ppt.person_type_id = ptu.person_type_id
85: AND ppt.system_person_type IN ('EMP', 'EMP_APL', 'CWK','EX_EMP', 'EX_CWK')
86: AND ( p_person_type IS NULL

Line 129: per_person_types ppt

125: hxc_tk_group_query_criteria htgqc,
126: per_all_people_f ppf,
127: per_all_assignments_f paa,
128: per_person_type_usages_f ptu,
129: per_person_types ppt
130: WHERE ppf.person_id = paa.person_id
131: AND ppt.person_type_id = ptu.person_type_id
132: AND ppt.system_person_type IN ('EMP', 'EMP_APL', 'CWK','EX_EMP')
133: AND ptu.person_id = ppf.person_id