APPS.CS_WF_AUTO_NTFY_UPDATE_PKG dependencies on CS_PARTY_ROLES_TL

Line 1081: l_party_role_name cs_party_roles_tl.name%TYPE;

1077: l_contact_point_id_list VARCHAR2(2000);
1078: l_notify_subject_id NUMBER;
1079:
1080: l_party_role_code cs_party_role_group_maps.party_role_code%TYPE;
1081: l_party_role_name cs_party_roles_tl.name%TYPE;
1082: l_party_role_group_code cs_party_role_group_maps.party_role_group_code%TYPE;
1083:
1084: l_notify_party_role_list VARCHAR2(2000);
1085: l_notify_relsr_party_role_list VARCHAR2(2000);

Line 1359: cs_party_roles_tl cpr

1355: cpr.name,
1356: cpr.party_role_code
1357: FROM hz_contact_points hcp,
1358: cs_hz_sr_contact_points cshcp,
1359: cs_party_roles_tl cpr
1360: WHERE
1361: hcp.CONTACT_POINT_TYPE = 'EMAIL'
1362: AND hcp.CONTACT_POINT_ID = l_contact_point_id
1363: AND hcp.CONTACT_POINT_ID = cshcp.CONTACT_POINT_ID

Line 1378: cs_party_roles_tl cpr

1374: cpr.name,
1375: cpr.party_role_code
1376: FROM per_all_people_f ppf,
1377: cs_hz_sr_contact_points cshcp,
1378: cs_party_roles_tl cpr
1379: WHERE
1380: cshcp.CONTACT_POINT_TYPE = 'EMAIL'
1381: AND ppf.PERSON_ID = l_contact_point_id
1382: AND cshcp.PARTY_ID = ppf.person_id