APPS.OTA_TDB_BUS dependencies on PER_PERSON_TYPE_USAGES_F

Line 650: /* Changed the following query to support PTU. Added the table Per_Person_type_Usages_F. */

646: p_date_booking_placed --evt.course_start_date
647: BETWEEN paf.effective_start_date AND paf.effective_end_date) );
648:
649: /* For Bug 1706107 */
650: /* Changed the following query to support PTU. Added the table Per_Person_type_Usages_F. */
651: /* Added the person type 'CWK' and removed 'EMP_APL' -- Enh No 2530860 */
652: CURSOR c_student_rehire IS
653: SELECT paf.ROWID
654: FROM per_all_assignments_f paf, ota_events evt ,

Line 656: per_person_type_usages_f ptu,

652: CURSOR c_student_rehire IS
653: SELECT paf.ROWID
654: FROM per_all_assignments_f paf, ota_events evt ,
655: per_all_people_f ppf,
656: per_person_type_usages_f ptu,
657: per_person_types ppt
658: WHERE paf.person_id = l_person_id
659: AND ppf.person_id = l_person_id
660: AND ptu.person_id = ppf.person_id

Line 711: /* Changed the following query to support PTU. Added the table Per_Person_type_Usages_F. */

707: AND p_date_booking_placed BETWEEN paf.effective_start_date
708: AND paf.effective_end_date;
709:
710: /* For Bug 1706107 */
711: /* Changed the following query to support PTU. Added the table Per_Person_type_Usages_F. */
712: /* Added the person type 'CWK' and removed 'EMP_APL' */
713: CURSOR c_contact_rehire IS
714: SELECT paf.ROWID
715: FROM per_all_assignments_f paf ,

Line 717: per_person_type_usages_f ptu,

713: CURSOR c_contact_rehire IS
714: SELECT paf.ROWID
715: FROM per_all_assignments_f paf ,
716: per_all_people_f ppf,
717: per_person_type_usages_f ptu,
718: per_person_types ppt
719: WHERE paf.person_id = l_person_id
720: AND ppf.person_id = l_person_id
721: AND ptu.person_id = ppf.person_id