DBA Data[Home] [Help]

APPS.CSZ_SERVICEREQUEST_UTIL_PVT dependencies on CS_PARTY_ROLES_VL

Line 1453: from cs_hz_sr_contact_points cp, CS_PARTY_ROLES_VL partyrole

1449: l_concat_party_role_names varchar2(360) DEFAULT NULL;
1450: -- Person cursor
1451: cursor personCursor(p_incident_id NUMBER, p_party_id NUMBER) is
1452: select distinct partyrole.name
1453: from cs_hz_sr_contact_points cp, CS_PARTY_ROLES_VL partyrole
1454: where cp.party_role_code = partyrole.party_role_code
1455: and cp.incident_id = p_incident_id
1456: and
1457: (

Line 1474: from cs_hz_sr_contact_points cp, CS_PARTY_ROLES_VL partyrole

1470: cursor OrgEmpRelationshipCursor(p_incident_id NUMBER,
1471: p_party_id NUMBER,
1472: p_party_type VARCHAR2) is
1473: select distinct partyrole.name
1474: from cs_hz_sr_contact_points cp, CS_PARTY_ROLES_VL partyrole
1475: where cp.party_role_code = partyrole.party_role_code
1476: and cp.incident_id = p_incident_id
1477: and
1478: (