DBA Data[Home] [Help]

APPS.OKC_DELIVERABLE_PROCESS_PVT dependencies on PER_ALL_PEOPLE_F

Line 6904: from per_all_people_f

6900: fnd_user_rec fnd_user_cur%ROWTYPE;
6901:
6902: CURSOR contact_cur IS
6903: select email_address
6904: from per_all_people_f
6905: where person_id = p_contact_id
6906: --and trunc(sysdate) < nvl(effective_end_date, trunc(sysdate + 1));
6907: and trunc(sysdate) between effective_start_date and effective_end_date;
6908:

Line 6985: from per_all_people_f

6981: ) RETURN VARCHAR2
6982: IS
6983: CURSOR contact_cur IS
6984: select 'X'
6985: from per_all_people_f
6986: where person_id = p_contact_id
6987: and trunc(sysdate) < nvl(effective_end_date, trunc(sysdate + 1));
6988:
6989: