APPS.AHL_PRD_NONROUTINE_PVT dependencies on PER_PEOPLE_F

Line 936: from per_people_f

932: BEGIN
933: Select full_name
934: into
935: l_contact_name
936: from per_people_f
937: where person_id
938: = p_x_sr_task_rec.contact_id
939: and trunc(sysdate) between trunc(nvl(effective_start_date,sysdate))
940: and trunc(nvl(effective_end_date,sysdate));

Line 975: from per_people_f

971: BEGIN
972: Select person_id
973: into
974: l_contact_id
975: from per_people_f
976: where full_name = p_x_sr_task_rec.contact_name
977: and trunc(sysdate) between trunc(nvl(effective_start_date,sysdate))
978: and trunc(nvl(effective_end_date,sysdate));
979:

Line 1238: from per_people_f

1234: BEGIN
1235: Select full_name
1236: into
1237: l_contact_name
1238: from per_people_f
1239: where person_id
1240: = p_x_sr_task_rec.contact_id
1241: and trunc(sysdate) between trunc(nvl(effective_start_date,sysdate))
1242: and trunc(nvl(effective_end_date,sysdate));

Line 1276: from per_people_f

1272: BEGIN
1273: Select person_id
1274: into
1275: l_contact_id
1276: from per_people_f
1277: where full_name = p_x_sr_task_rec.contact_name
1278: and trunc(sysdate) between trunc(nvl(effective_start_date,sysdate))
1279: and trunc(nvl(effective_end_date,sysdate));
1280: