APPS.OTA_LP_NOTIFY_SS dependencies on PER_ALL_ASSIGNMENTS_F
Line 412: per_all_assignments_f paf
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
416: AND paf.supervisor_id = ppf.person_id