APPS.OTA_LEARNER_ACCESS_UTIL dependencies on PER_ALL_PEOPLE_F

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 928: FUNCTION emp_has_valid_dates(p_person_id per_all_people_f.person_id%TYPE

924:
925: return 'N';
926: end ext_has_access;
927:
928: FUNCTION emp_has_valid_dates(p_person_id per_all_people_f.person_id%TYPE
929: ,p_event_id ota_events.event_id%TYPE)
930: RETURN VARCHAR2 IS
931: l_event_start_date DATE;
932: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

Line 974: l_effective_start_date PER_ALL_PEOPLE_F.effective_start_date%type;

970: And OEV.parent_offering_id = OFR.offering_id
971: And OFR.delivery_mode_id = OCU.category_usage_id;
972:
973: l_synchronous_flag ota_category_usages.synchronous_flag%type;
974: l_effective_start_date PER_ALL_PEOPLE_F.effective_start_date%type;
975: l_event_status ota_events.event_status%type;
976: l_secure_event_flag ota_events.secure_event_flag%type;
977: l_organization_id ota_events.organization_id%type;
978: l_start_date otv_scheduled_events.course_start_date%type;

Line 2123: ,p_person_id in per_all_people_f.person_id%type

2119: end lrn_can_self_enroll_in_cert;
2120:
2121: function learner_can_enroll_in_path(
2122: p_learning_path_id in ota_learning_paths.learning_path_id%TYPE
2123: ,p_person_id in per_all_people_f.person_id%type
2124: ,p_party_id in hz_parties.party_id%type) return varchar2
2125: IS
2126: CURSOR csr_get_lp_details IS
2127: SELECT public_flag, start_date_active

Line 2152: ,p_person_id in per_all_people_f.person_id%type

2148: END learner_can_enroll_in_path;
2149:
2150: function learner_can_enroll_in_cert(
2151: p_certification_id in ota_certifications_b.certification_id%type
2152: ,p_person_id in per_all_people_f.person_id%type
2153: ,p_party_id in hz_parties.party_id%type) return varchar2
2154: IS
2155: CURSOR csr_get_cert_details IS
2156: SELECT public_flag, start_date_active