DBA Data[Home] [Help]

APPS.OKC_DELIVERABLE_PROCESS_PVT dependencies on PER_ALL_PEOPLE_F

Line 7305: from per_all_people_f

7301: fnd_user_rec fnd_user_cur%ROWTYPE;
7302:
7303: CURSOR contact_cur IS
7304: select email_address
7305: from per_all_people_f
7306: where person_id = p_contact_id
7307: --and trunc(sysdate) < nvl(effective_end_date, trunc(sysdate + 1));
7308: and trunc(sysdate) between effective_start_date and effective_end_date;
7309:

Line 7386: from per_all_people_f

7382: ) RETURN VARCHAR2
7383: IS
7384: CURSOR contact_cur IS
7385: select 'X'
7386: from per_all_people_f
7387: where person_id = p_contact_id
7388: and trunc(sysdate) < nvl(effective_end_date, trunc(sysdate + 1));
7389:
7390: