APPS.IGS_EN_SPLACEMENTS_API dependencies on IGS_PE_CONTACTS_V

Line 42: FROM IGS_PE_CONTACTS_V

38: WHERE person_id=c_person_id
39: AND employment_history_id=c_emp_hist_id;
40:
41: Cursor cur_c2 IS SELECT *
42: FROM IGS_PE_CONTACTS_V
43: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'
44: AND OWNER_TABLE_ID = P_PERSON_ID
45: AND CONTACT_POINT_ID = P_PHONE_ID
46: AND CONTACT_POINT_TYPE = 'PHONE'

Line 50: FROM IGS_PE_CONTACTS_V

46: AND CONTACT_POINT_TYPE = 'PHONE'
47: FOR UPDATE NOWAIT;
48:
49: Cursor cur_c3 IS SELECT *
50: FROM IGS_PE_CONTACTS_V
51: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'
52: AND OWNER_TABLE_ID = P_PERSON_ID
53: AND CONTACT_POINT_ID = P_EMAIL_ID
54: AND CONTACT_POINT_TYPE = 'EMAIL'

Line 78: l_email_address IGS_PE_CONTACTS_V.EMAIL_ADDRESS%TYPE := P_EMAIL_ADDRESS;

74: l_contact_point_ovn HZ_CONTACT_POINTS.OBJECT_VERSION_NUMBER%TYPE :=NULL;
75: l_phone HZ_CONTACT_POINTS.PHONE_NUMBER%TYPE := P_PHONE;
76: l_phone_id HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE := P_PHONE_ID;
77: l_phone_ovn HZ_CONTACT_POINTS.OBJECT_VERSION_NUMBER%TYPE := P_PHONE_OVN;
78: l_email_address IGS_PE_CONTACTS_V.EMAIL_ADDRESS%TYPE := P_EMAIL_ADDRESS;
79: l_email_id IGS_PE_CONTACTS_V.EMAIL_ADDRESS%TYPE := P_EMAIL_ID;
80: l_email_ovn HZ_CONTACT_POINTS.OBJECT_VERSION_NUMBER%TYPE := P_EMAIL_OVN;
81: l_employment_history_id IGS_AD_EMP_DTL.EMPLOYMENT_HISTORY_ID%TYPE := P_EMPLOYMENT_HISTORY_ID;
82:

Line 79: l_email_id IGS_PE_CONTACTS_V.EMAIL_ADDRESS%TYPE := P_EMAIL_ID;

75: l_phone HZ_CONTACT_POINTS.PHONE_NUMBER%TYPE := P_PHONE;
76: l_phone_id HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE := P_PHONE_ID;
77: l_phone_ovn HZ_CONTACT_POINTS.OBJECT_VERSION_NUMBER%TYPE := P_PHONE_OVN;
78: l_email_address IGS_PE_CONTACTS_V.EMAIL_ADDRESS%TYPE := P_EMAIL_ADDRESS;
79: l_email_id IGS_PE_CONTACTS_V.EMAIL_ADDRESS%TYPE := P_EMAIL_ID;
80: l_email_ovn HZ_CONTACT_POINTS.OBJECT_VERSION_NUMBER%TYPE := P_EMAIL_OVN;
81: l_employment_history_id IGS_AD_EMP_DTL.EMPLOYMENT_HISTORY_ID%TYPE := P_EMPLOYMENT_HISTORY_ID;
82:
83: l_emp_obj_ver_no IGS_AD_EMP_DTL.OBJECT_VERSION_NUMBER%TYPE;