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 955: per_all_assignments_f assg,

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

Line 977: per_all_assignments_f assg

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

Line 1457: from per_all_assignments_f

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

Line 1465: l_per_organization_id PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID%TYPE;

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

Line 1548: FROM per_all_assignments_f a

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

Line 2459: FROM per_all_assignments_f a,

2455: --
2456:
2457: CURSOR csr_supervisor_id IS
2458: SELECT a.supervisor_id, per.full_name
2459: FROM per_all_assignments_f a,
2460: per_all_people_f per
2461: WHERE a.person_id = p_person_id
2462: AND per.person_id = a.supervisor_id
2463: AND a.primary_flag = 'Y'