APPS.OTA_LEARNER_ACCESS_UTIL dependencies on PER_ALL_PEOPLE

Line 453: ,per_all_people_f perp

449: p_as_of date) is
450: select asg.assignment_id
451: from per_all_assignments_f asg
452: ,per_person_types ppt
453: ,per_all_people_f perp
454: ,per_person_type_usages_f ptu
455: where asg.person_id = p_person_id
456: and asg.person_id = perp.person_id
457: and perp.person_id =ptu.person_id

Line 506: ,per_all_people_f perp

502: x.organization_id = p_organization_id and
503: x.sub_org_relative_level > 0
504: ) orgs
505: ,per_person_types ppt
506: ,per_all_people_f perp
507: ,per_person_type_usages_f ptu
508: where asg.person_id = p_person_id
509: and asg.person_id = perp.person_id
510: and perp.person_id =ptu.person_id

Line 804: p_person_id per_all_people.person_id%type) is

800: ) return boolean is
801:
802: cursor person_bookings(
803: p_event_id ota_events.event_id%type,
804: p_person_id per_all_people.person_id%type) is
805: select 1
806: from ota_delegate_bookings book,
807: ota_booking_status_types stype
808: where book.delegate_person_id = p_person_id and

Line 941: FUNCTION emp_has_valid_dates(p_person_id per_all_people_f.person_id%TYPE

937:
938: return 'N';
939: end ext_has_access;
940:
941: FUNCTION emp_has_valid_dates(p_person_id per_all_people_f.person_id%TYPE
942: ,p_event_id ota_events.event_id%TYPE)
943: RETURN VARCHAR2 IS
944: l_event_start_date DATE;
945: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

Line 987: l_effective_start_date PER_ALL_PEOPLE_F.effective_start_date%type;

983: And OEV.parent_offering_id = OFR.offering_id
984: And OFR.delivery_mode_id = OCU.category_usage_id;
985:
986: l_synchronous_flag ota_category_usages.synchronous_flag%type;
987: l_effective_start_date PER_ALL_PEOPLE_F.effective_start_date%type;
988: l_event_status ota_events.event_status%type;
989: l_secure_event_flag ota_events.secure_event_flag%type;
990: l_organization_id ota_events.organization_id%type;
991: l_start_date otv_scheduled_events.course_start_date%type;

Line 2136: ,p_person_id in per_all_people_f.person_id%type

2132: end lrn_can_self_enroll_in_cert;
2133:
2134: function learner_can_enroll_in_path(
2135: p_learning_path_id in ota_learning_paths.learning_path_id%TYPE
2136: ,p_person_id in per_all_people_f.person_id%type
2137: ,p_party_id in hz_parties.party_id%type) return varchar2
2138: IS
2139: CURSOR csr_get_lp_details IS
2140: SELECT public_flag, start_date_active

Line 2165: ,p_person_id in per_all_people_f.person_id%type

2161: END learner_can_enroll_in_path;
2162:
2163: function learner_can_enroll_in_cert(
2164: p_certification_id in ota_certifications_b.certification_id%type
2165: ,p_person_id in per_all_people_f.person_id%type
2166: ,p_party_id in hz_parties.party_id%type) return varchar2
2167: IS
2168: CURSOR csr_get_cert_details IS
2169: SELECT public_flag, start_date_active