DBA Data[Home] [Help]

APPS.CSZ_SERVICEREQUEST_UTIL_PVT dependencies on CS_PARTY_ROLES_VL

Line 1452: from cs_hz_sr_contact_points cp, CS_PARTY_ROLES_VL partyrole

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

Line 1473: from cs_hz_sr_contact_points cp, CS_PARTY_ROLES_VL partyrole

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