APPS.OTA_LP_NOTIFY_SS dependencies on PER_ALL_PEOPLE_F

Line 60: l_creator_person_name PER_ALL_PEOPLE_F.full_name%TYPE;

56:
57:
58: l_user_name varchar2(80);
59: l_learner_full_name varchar2(240);
60: l_creator_person_name PER_ALL_PEOPLE_F.full_name%TYPE;
61:
62: l_creator_person_id per_all_people_f.person_id%type;
63: l_person_id per_all_people_f.person_id%type;
64: l_contact_id number;

Line 62: l_creator_person_id per_all_people_f.person_id%type;

58: l_user_name varchar2(80);
59: l_learner_full_name varchar2(240);
60: l_creator_person_name PER_ALL_PEOPLE_F.full_name%TYPE;
61:
62: l_creator_person_id per_all_people_f.person_id%type;
63: l_person_id per_all_people_f.person_id%type;
64: l_contact_id number;
65: l_contact_name HZ_PARTIES.party_name%TYPE;
66:

Line 63: l_person_id per_all_people_f.person_id%type;

59: l_learner_full_name varchar2(240);
60: l_creator_person_name PER_ALL_PEOPLE_F.full_name%TYPE;
61:
62: l_creator_person_id per_all_people_f.person_id%type;
63: l_person_id per_all_people_f.person_id%type;
64: l_contact_id number;
65: l_contact_name HZ_PARTIES.party_name%TYPE;
66:
67: l_person_details OTA_LEARNER_ENROLL_SS.csr_person_to_enroll_details%ROWTYPE;

Line 146: FROM per_all_people_f ppf

142:
143:
144: CURSOR csr_get_person_name(p_person_id IN number) IS
145: SELECT ppf.full_name
146: FROM per_all_people_f ppf
147: WHERE person_id = p_person_id
148: AND TRUNC(SYSDATE) BETWEEN effective_start_date AND effective_end_date;--Bug 13826398
149:
150: l_lp_details csr_get_lp_details%ROWTYPE;

Line 411: per_all_people_f ppf,

407: CURSOR csr_get_manager_name IS
408: SELECT ppf.full_name, ppf.person_id
409: FROM ota_lp_enrollments lpe,
410: ota_learning_paths lps,
411: per_all_people_f ppf,
412: per_all_assignments_f paf
413: WHERE trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date
414: AND trunc(sysdate) between paf.effective_start_date and paf.effective_end_date
415: AND paf.person_id = lpe.person_id

Line 479: per_all_people_f ppf

475: CURSOR csr_get_creator_name IS
476: SELECT ppf.full_name, ppf.person_id
477: FROM ota_lp_enrollments lpe,
478: ota_learning_paths lps,
479: per_all_people_f ppf
480: WHERE trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date
481: AND ppf.person_id = lpe.creator_person_id
482: AND lpe.lp_enrollment_id = l_lp_enrollment_id
483: AND lpe.learning_path_id = lps.learning_path_id;