APPS.HR_ASSIGNMENT_API dependencies on PER_PERSON_TYPES

Line 230: FROM PER_PERSON_TYPE_USAGES_F PTU, PER_PERSON_TYPES PPT

226:
227: -- ER FPT
228: cursor c3(p_date_end date) is
229: SELECT 1
230: FROM PER_PERSON_TYPE_USAGES_F PTU, PER_PERSON_TYPES PPT
231: WHERE PTU.PERSON_ID = P_PERSON_ID
232: AND PTU.EFFECTIVE_START_DATE > p_DATE_END
233: AND PTU.PERSON_TYPE_ID = PPT.PERSON_TYPE_ID
234: AND PPT.SYSTEM_PERSON_TYPE IN ('EMP','CWK');

Line 240: ,per_person_types ppt

236: cursor csr_ptu_row (p_date_received in date ) is
237: select ptu.person_type_usage_id,
238: ptu.effective_start_date
239: from per_person_type_usages_f ptu
240: ,per_person_types ppt
241: where ptu.person_id = p_person_id
242: and ptu.effective_start_date > p_date_received
243: and ptu.person_type_id = ppt.person_type_id
244: and ppt.system_person_type = 'EX_APL'

Line 287: from per_person_type_usages_f ptu, per_person_types ppt

283: l_apl_person_type_id number;
284: l_max_ptu_end_date date;
285: cursor get_max_end_date(p_date_received date) is
286: select nvl(max(effective_end_date),hr_api.g_eot)
287: from per_person_type_usages_f ptu, per_person_types ppt
288: where ptu.person_type_id = ppt.person_type_id
289: and ppt.system_person_type = 'APL'
290: and ptu.effective_start_date > p_date_received;
291:

Line 718: ,per_person_types ppt

714:
715: cursor csr_ptu_row (p_date_received in date ) is
716: select ptu.effective_start_date
717: from per_person_type_usages_f ptu
718: ,per_person_types ppt
719: where ptu.person_id = p_person_id
720: and ptu.effective_start_date > p_date_received
721: and ptu.person_type_id = ppt.person_type_id
722: and ppt.system_person_type = 'EX_APL'