APPS.OTA_LP_XMLP_PKG dependencies on PER_ALL_PEOPLE_F
Line 42: FROM per_all_people_f ppf
38: FUNCTION C_LEARNER_NAME_p return varchar2 IS
39:
40: CURSOR c_learner_name_csr IS
41: SELECT ppf.full_name 42: FROM per_all_people_f ppf 43: WHERE trunc(sysdate) BETWEEN nvl(ppf.effective_start_date, trunc(sysdate)) AND nvl(ppf.effective_end_date, trunc(sysdate))
44: AND ppf.person_id = P_LEARNER_ID;
45:
46: BEGIN