APPS.OKC_REP_QA_CHECK_PVT dependencies on PER_ALL_PEOPLE_F

Line 1269: FROM per_all_people_f per

1265: WHERE person_id = p_contact_id;
1266:
1267: CURSOR employee_name_csr IS
1268: SELECT per.full_name contact_name
1269: FROM per_all_people_f per
1270: WHERE per.person_id = p_contact_id
1271: AND per.effective_start_date = (SELECT MAX(effective_start_date)
1272: FROM per_all_people_f
1273: WHERE person_id = per.person_id);

Line 1272: FROM per_all_people_f

1268: SELECT per.full_name contact_name
1269: FROM per_all_people_f per
1270: WHERE per.person_id = p_contact_id
1271: AND per.effective_start_date = (SELECT MAX(effective_start_date)
1272: FROM per_all_people_f
1273: WHERE person_id = per.person_id);
1274:
1275:
1276: employee_contact_rec employee_contact_csr%ROWTYPE;