APPS.CS_WF_AUTO_NTFY_UPDATE_PKG dependencies on CS_PARTY_ROLES_TL

Line 1080: l_party_role_name cs_party_roles_tl.name%TYPE;

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

Line 1355: cs_party_roles_tl cpr

1351: cpr.name,
1352: cpr.party_role_code
1353: FROM hz_contact_points hcp,
1354: cs_hz_sr_contact_points cshcp,
1355: cs_party_roles_tl cpr
1356: WHERE
1357: hcp.CONTACT_POINT_TYPE = 'EMAIL'
1358: AND hcp.CONTACT_POINT_ID = l_contact_point_id
1359: AND hcp.CONTACT_POINT_ID = cshcp.CONTACT_POINT_ID

Line 1374: cs_party_roles_tl cpr

1370: cpr.name,
1371: cpr.party_role_code
1372: FROM per_all_people_f ppf,
1373: cs_hz_sr_contact_points cshcp,
1374: cs_party_roles_tl cpr
1375: WHERE
1376: cshcp.CONTACT_POINT_TYPE = 'EMAIL'
1377: AND ppf.PERSON_ID = l_contact_point_id
1378: AND cshcp.PARTY_ID = ppf.person_id