APPS.CS_WF_AUTO_NTFY_UPDATE_PKG dependencies on HZ_PARTIES

Line 1198: AND owner_table_name = 'HZ_PARTIES'

1194: SELECT email_address
1195: FROM hz_contact_points
1196: WHERE contact_point_id = p_contact_point_id
1197: AND contact_point_type = 'EMAIL'
1198: AND owner_table_name = 'HZ_PARTIES'
1199: AND owner_table_id = p_party_id ;
1200:
1201: -- Get any customer email address starting with the primary email address.
1202:

Line 1207: AND owner_table_name = 'HZ_PARTIES'

1203: CURSOR get_any_cust_email_address(p_party_id IN NUMBER) IS
1204: SELECT email_address
1205: FROM hz_contact_points
1206: WHERE contact_point_type = 'EMAIL'
1207: AND owner_table_name = 'HZ_PARTIES'
1208: AND owner_table_id = p_party_id
1209: ORDER BY Primary_flag DESC;
1210:
1211: -- Get the email information from the HR schema for the primary contact.

Line 1227: FROM hz_parties hzp,

1223:
1224: CURSOR get_prim_cont_party_info_reln (p_party_id IN NUMBER) IS
1225: SELECT hzp.person_first_name first_name,
1226: hzp.person_last_name last_name
1227: FROM hz_parties hzp,
1228: hz_relationships hzr
1229: WHERE hzr.PARTY_ID = p_party_id
1230: AND hzr.SUBJECT_ID = hzp.PARTY_ID
1231: AND hzr.SUBJECT_TYPE = 'PERSON';

Line 1236: FROM hz_parties hzp

1232:
1233: CURSOR get_prim_cont_party_info_per (p_party_id IN NUMBER) IS
1234: SELECT hzp.person_first_name first_name,
1235: hzp.person_last_name last_name
1236: FROM hz_parties hzp
1237: WHERE hzp.PARTY_ID = p_party_id;
1238:
1239: CURSOR get_prim_cont_party_info_empl (p_party_id IN NUMBER) IS
1240: SELECT ppf.first_name first_name,

Line 1524: -- 3) HZ_PARTIES - for contact type = PERSON

1520: -- We use this contact point id to go against the following 2 tables to derive the
1521: -- contact's full name :
1522: -- 1) PER_ALL_PEOPLE_F - for contact type = EMPLOYEE
1523: -- 2) HZ_RELATIONSHIPS - for contact type = PARTY_RELATIONSHIP
1524: -- 3) HZ_PARTIES - for contact type = PERSON
1525:
1526: l_tmp_contact_point_id NUMBER;
1527:
1528: CURSOR sel_contact_name_csr IS

Line 1533: FROM hz_parties hzp,

1529: SELECT hzp.person_first_name first_name,
1530: hzp.person_last_name last_name,
1531: cshcp.contact_type,
1532: cshcp.contact_point_id
1533: FROM hz_parties hzp,
1534: hz_relationships hzr,
1535: cs_hz_sr_contact_points cshcp
1536: WHERE cshcp.INCIDENT_ID = l_request_id
1537: AND cshcp.sr_contact_point_id = l_tmp_contact_point_id

Line 1548: FROM hz_parties hzp,

1544: SELECT hzp.person_first_name first_name,
1545: hzp.person_last_name last_name,
1546: cshcp.contact_type,
1547: cshcp.contact_point_id
1548: FROM hz_parties hzp,
1549: cs_hz_sr_contact_points cshcp
1550: WHERE cshcp.INCIDENT_ID = l_request_id
1551: AND cshcp.sr_contact_point_id = l_tmp_contact_point_id
1552: AND cshcp.CONTACT_POINT_TYPE = 'EMAIL'

Line 4126: FROM HZ_PARTIES

4122:
4123:
4124: CURSOR sel_contact_party_name_csr IS
4125: SELECT PARTY_NAME
4126: FROM HZ_PARTIES
4127: WHERE
4128: PARTY_ID = l_contact_party_id;
4129:
4130: BEGIN

Line 6251: HZ_PARTIES RA2,

6247: CS_INCIDENT_SEVERITIES_TL SEVERITY,
6248: CS_INCIDENT_STATUSES_VL STATUS,
6249: --CS_INCIDENT_URGENCIES_VL URGENCY,
6250: CS_INCIDENT_URGENCIES_TL URGENCY,
6251: HZ_PARTIES RA2,
6252: CS_LOOKUPS CSLKUP,
6253: --MTL_SYSTEM_ITEMS_VL MTL
6254: MTL_SYSTEM_ITEMS_TL MTL
6255: WHERE INC.INCIDENT_NUMBER = l_request_number

Line 6774: FROM HZ_PARTIES

6770:
6771:
6772: CURSOR sel_contact_party_name_csr IS
6773: SELECT PARTY_NAME
6774: FROM HZ_PARTIES
6775: WHERE
6776: PARTY_ID = p_party_id;
6777:
6778: l_int_profile varchar2(30);