APPS.OTA_LEARNER_ENROLL_SS dependencies on PER_ALL_ASSIGNMENTS_F

Line 40: ,p_assignment_id IN PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE

36: PROCEDURE ProcessSaveEnrollment( p_event_id IN VARCHAR2
37: ,p_extra_information IN VARCHAR2
38: ,p_mode IN VARCHAR2
39: ,p_cost_centers IN VARCHAR2
40: ,p_assignment_id IN PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE
41: ,p_business_group_id_from IN PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE
42: ,p_business_group_name IN PER_BUSINESS_GROUPS.name%TYPE
43: ,p_organization_id IN PER_ALL_ASSIGNMENTS_F.organization_id%TYPE
44: ,p_person_id IN PER_ALL_PEOPLE_F.person_id%type

Line 41: ,p_business_group_id_from IN PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE

37: ,p_extra_information IN VARCHAR2
38: ,p_mode IN VARCHAR2
39: ,p_cost_centers IN VARCHAR2
40: ,p_assignment_id IN PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE
41: ,p_business_group_id_from IN PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE
42: ,p_business_group_name IN PER_BUSINESS_GROUPS.name%TYPE
43: ,p_organization_id IN PER_ALL_ASSIGNMENTS_F.organization_id%TYPE
44: ,p_person_id IN PER_ALL_PEOPLE_F.person_id%type
45: -- Added for External LearnerSupport

Line 43: ,p_organization_id IN PER_ALL_ASSIGNMENTS_F.organization_id%TYPE

39: ,p_cost_centers IN VARCHAR2
40: ,p_assignment_id IN PER_ALL_ASSIGNMENTS_F.assignment_id%TYPE
41: ,p_business_group_id_from IN PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE
42: ,p_business_group_name IN PER_BUSINESS_GROUPS.name%TYPE
43: ,p_organization_id IN PER_ALL_ASSIGNMENTS_F.organization_id%TYPE
44: ,p_person_id IN PER_ALL_PEOPLE_F.person_id%type
45: -- Added for External LearnerSupport
46: ,p_delegate_contact_id IN NUMBER
47: ,p_booking_id out nocopy OTA_DELEGATE_BOOKINGS.Booking_id%type

Line 956: per_all_assignments_f assg,

952: pcak.cost_allocation_keyflex_id,
953: pcak.concatenated_segments,
954: pcaf.proportion
955: FROM per_all_people_f per,
956: per_all_assignments_f assg,
957: pay_cost_allocations_f pcaf,
958: pay_cost_allocation_keyflex pcak
959: WHERE per.person_id = p_person_id
960: AND per.person_id = assg.person_id

Line 978: per_all_assignments_f assg

974: SELECT assg.assignment_id,
975: assg.business_group_id,
976: assg.organization_id
977: FROM per_all_people_f per,
978: per_all_assignments_f assg
979: WHERE per.person_id = p_delegate_id
980: AND per.person_id = assg.person_id
981: AND trunc(sysdate) between nvl(assg.effective_start_date,trunc(sysdate))
982: and nvl(assg.effective_end_date,trunc(sysdate+1))

Line 1458: from per_all_assignments_f

1454: where event_id = p_event_id;
1455:
1456: CURSOR C_GET_ORG_ID is
1457: SELECT organization_id
1458: from per_all_assignments_f
1459: where person_id = p_delegate_id and
1460: trunc(sysdate) between effective_start_date and
1461: effective_end_date;
1462:

Line 1466: l_per_organization_id PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID%TYPE;

1462:
1463:
1464: l_secure_flag varchar2(1);
1465: l_evt_organization_id OTA_EVENTS.ORGANIZATION_ID%TYPE;
1466: l_per_organization_id PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID%TYPE;
1467: l_return_value varchar2(2000);
1468:
1469: BEGIN
1470:

Line 1549: FROM per_all_assignments_f a

1545: ,p_position_id OTA_EVENT_ASSOCIATIONS.position_id%TYPE
1546: ,p_course_start_date
1547: otv_scheduled_events.course_start_date%type) IS
1548: SELECT a.assignment_id
1549: FROM per_all_assignments_f a
1550: WHERE a.person_id = p_delegate_id
1551: --Modified for bug#5032859
1552: AND( nvl(fnd_profile.value('OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS'),'N') = 'Y'
1553: OR

Line 2467: FROM per_all_assignments_f a,

2463: --
2464:
2465: CURSOR csr_supervisor_id IS
2466: SELECT a.supervisor_id, per.full_name
2467: FROM per_all_assignments_f a,
2468: per_all_people_f per
2469: WHERE a.person_id = p_person_id
2470: AND per.person_id = a.supervisor_id
2471: AND a.primary_flag = 'Y'