APPS.AHL_PRD_NONROUTINE_PVT dependencies on PER_PEOPLE_F

Line 849: from per_people_f

845: BEGIN
846: Select full_name
847: into
848: l_contact_name
849: from per_people_f
850: where person_id
851: = p_x_sr_task_rec.contact_id
852: and trunc(sysdate) between trunc(nvl(effective_start_date,sysdate))
853: and trunc(nvl(effective_end_date,sysdate));

Line 888: from per_people_f

884: BEGIN
885: Select person_id
886: into
887: l_contact_id
888: from per_people_f
889: where full_name = p_x_sr_task_rec.contact_name
890: and trunc(sysdate) between trunc(nvl(effective_start_date,sysdate))
891: and trunc(nvl(effective_end_date,sysdate));
892:

Line 1102: from per_people_f

1098: BEGIN
1099: Select full_name
1100: into
1101: l_contact_name
1102: from per_people_f
1103: where person_id
1104: = p_x_sr_task_rec.contact_id
1105: and trunc(sysdate) between trunc(nvl(effective_start_date,sysdate))
1106: and trunc(nvl(effective_end_date,sysdate));

Line 1140: from per_people_f

1136: BEGIN
1137: Select person_id
1138: into
1139: l_contact_id
1140: from per_people_f
1141: where full_name = p_x_sr_task_rec.contact_name
1142: and trunc(sysdate) between trunc(nvl(effective_start_date,sysdate))
1143: and trunc(nvl(effective_end_date,sysdate));
1144: