eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_LP_NOTIFY_SS dependencies on PER_ALL_PEOPLE_F

Line 59: l_creator_person_name PER_ALL_PEOPLE_F.full_name%TYPE;

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

Line 61: l_creator_person_id per_all_people_f.person_id%type;

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

Line 62: l_person_id per_all_people_f.person_id%type;

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

Line 145: FROM per_all_people_f ppf

141:
142:
143: CURSOR csr_get_person_name(p_person_id IN number) IS
144: SELECT ppf.full_name
145: FROM per_all_people_f ppf
146: WHERE person_id = p_person_id;
147:
148: l_lp_details csr_get_lp_details%ROWTYPE;
149: l_lpm_details csr_get_lpm_details%ROWTYPE;

Line 390: per_all_people_f ppf,

386: CURSOR csr_get_manager_name IS
387: SELECT ppf.full_name, ppf.person_id
388: FROM ota_lp_enrollments lpe,
389: ota_learning_paths lps,
390: per_all_people_f ppf,
391: per_all_assignments_f paf
392: WHERE trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date
393: AND trunc(sysdate) between paf.effective_start_date and paf.effective_end_date
394: AND paf.person_id = lpe.person_id

Line 458: per_all_people_f ppf

454: CURSOR csr_get_creator_name IS
455: SELECT ppf.full_name, ppf.person_id
456: FROM ota_lp_enrollments lpe,
457: ota_learning_paths lps,
458: per_all_people_f ppf
459: WHERE trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date
460: AND ppf.person_id = lpe.creator_person_id
461: AND lpe.lp_enrollment_id = l_lp_enrollment_id
462: AND lpe.learning_path_id = lps.learning_path_id;