APPS.HR_ASSIGNMENT_API dependencies on PER_PERSON_TYPE_USAGES_F

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 239: from per_person_type_usages_f ptu

235:
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

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 530: update per_person_type_usages_f

526: open get_max_end_date(l_date_recieved);
527: fetch get_max_end_date into l_max_ptu_end_date;
528: close get_max_end_date;
529:
530: update per_person_type_usages_f
531: set effective_end_date = l_max_ptu_end_date
532: where l_date_recieved between effective_start_date and effective_end_date
533: and person_type_id = l_apl_person_type_id;
534:

Line 537: delete from per_person_type_usages_f

533: and person_type_id = l_apl_person_type_id;
534:
535: hr_utility.set_location('At reverse_term_apln_fut',150);
536:
537: delete from per_person_type_usages_f
538: where effective_start_date > l_date_recieved
539: and person_type_id = l_apl_person_type_id;
540: -- merging PTU APL data
541:

Line 717: from per_person_type_usages_f ptu

713:
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