APPS.OTA_TDB_BUS dependencies on PER_ALL_ASSIGNMENTS_F

Line 633: FROM per_all_assignments_f paf, ota_events evt

629:
630: --
631: CURSOR c_student IS
632: SELECT paf.ROWID
633: FROM per_all_assignments_f paf, ota_events evt
634: WHERE paf.assignment_id = p_assignment_id
635: AND evt.event_id = p_event_id
636: AND (
637: evt.event_status = 'P'

Line 654: FROM per_all_assignments_f paf, ota_events evt ,

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 ,
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

Line 705: FROM per_all_assignments_f paf

701: --
702: /* For Bug 1514278 */
703: CURSOR c_contact IS
704: SELECT paf.ROWID
705: FROM per_all_assignments_f paf
706: WHERE paf.assignment_id = p_assignment_id
707: AND trunc(p_date_booking_placed) BETWEEN paf.effective_start_date
708: AND paf.effective_end_date;
709:

Line 715: FROM per_all_assignments_f paf ,

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 ,
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

Line 737: from per_all_assignments_f

733:
734:
735: Cursor c_assignment is
736: select person_id ,rowid
737: from per_all_assignments_f
738: where assignment_id = p_assignment_id ;
739: /* For Bug 1706107 */
740:
741: