DBA Data[Home] [Help]

APPS.OKC_REP_QA_CHECK_PVT dependencies on PER_ALL_PEOPLE_F

Line 730: FROM per_all_people_f per

726: WHERE person_id = p_contact_id;
727:
728: CURSOR employee_name_csr IS
729: SELECT per.full_name contact_name
730: FROM per_all_people_f per
731: WHERE per.person_id = p_contact_id
732: AND per.effective_start_date = (SELECT MAX(effective_start_date)
733: FROM per_all_people_f
734: WHERE person_id = per.person_id);

Line 733: FROM per_all_people_f

729: SELECT per.full_name contact_name
730: FROM per_all_people_f per
731: WHERE per.person_id = p_contact_id
732: AND per.effective_start_date = (SELECT MAX(effective_start_date)
733: FROM per_all_people_f
734: WHERE person_id = per.person_id);
735:
736:
737: employee_contact_rec employee_contact_csr%ROWTYPE;