DBA Data[Home] [Help]

APPS.PER_EVENTS_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 354: From per_all_assignments_f

350: and s.enabled_flag = 'Y';
351:
352: cursor csr_vacancy_id is
353: Select vacancy_id
354: From per_all_assignments_f
355: Where assignment_id = p_assignment_id
356: And p_session_date between effective_start_date and effective_end_date;
357:
358: l_vacancy_id number;

Line 650: from per_all_assignments_f asg

646:
647: cursor csr_get_party_id is
648: select max(party_id) from per_all_people_f
649: where person_id = (select asg.person_id
650: from per_all_assignments_f asg
651: where asg.assignment_id = X_Assignment_Id
652: and X_Date_Start between asg.effective_start_date
653: and asg.effective_end_date);
654: