APPS.HR_CANCEL_HIRE_API dependencies on PER_PERSON_TYPES

Line 111: l_system_person_type per_person_types.system_person_type%TYPE;

107: AND paa.period_of_service_id = pos.period_of_service_id;
108: --bug no 5105026 ends here
109:
110: l_proc VARCHAR2(72) := g_package||'cancel_hire';
111: l_system_person_type per_person_types.system_person_type%TYPE;
112: l_business_group_id NUMBER;
113: l_period_of_service_id NUMBER;
114: l_date_start DATE;
115: l_effective_date DATE;

Line 139: from per_person_type_usages_f ppf2 , per_person_types ppt2

135: where ppf1.person_id = p_person_id
136:
137: and ppf1.effective_start_date >
138: ( select max(ppf2.effective_start_date)
139: from per_person_type_usages_f ppf2 , per_person_types ppt2
140: where ppf2.person_id = p_person_id
141: and ppt2.person_type_id= ppf2.person_type_id
142: and ppt2.system_person_type='APL'
143: and ppt2.business_group_id = l_business_group_id )

Line 147: per_person_types ppt

143: and ppt2.business_group_id = l_business_group_id )
144:
145: and exists (
146: select '1' from
147: per_person_types ppt
148: where ppt.person_type_id= ppf1.person_type_id
149: and ppt.system_person_type='EX_APL'
150: and ppt.business_group_id = l_business_group_id )
151:

Line 165: per_person_types ppt

161: from per_person_type_usages_f pptf
162: where person_id = p_person_id
163: and exists (
164: select '1' from
165: per_person_types ppt
166: where ppt.person_type_id= pptf.person_type_id
167: and ppt.system_person_type='EMP'
168: and ppt.business_group_id = l_business_group_id );
169:

Line 176: per_person_types ppt

172: from per_person_type_usages_f pptf
173: where person_id = p_person_id
174: and exists (
175: select '1' from
176: per_person_types ppt
177: where ppt.person_type_id= pptf.person_type_id
178: and ppt.system_person_type='APL'
179: and ppt.business_group_id = l_business_group_id );
180:

Line 188: FROM per_person_types typ

184: ,p_person_id IN NUMBER
185: )
186: IS
187: SELECT typ.system_person_type
188: FROM per_person_types typ
189: ,per_person_type_usages_f ptu
190: WHERE
191: typ.system_person_type IN ('APL','EMP','EX_APL','EX_EMP','CWK','EX_CWK','OTHER')
192: AND typ.person_type_id = ptu.person_type_id