APPS.PV_PARTNER_ACCNT_MGMT_PVT dependencies on HZ_ROLE_RESPONSIBILITY

Line 702: FROM hz_role_responsibility

698: l_responsibility_id NUMBER;
699:
700: CURSOR C_Get_Resp(role_id NUMBER, resp_type VARCHAR2) IS
701: SELECT responsibility_id
702: FROM hz_role_responsibility
703: WHERE cust_account_role_id = role_id
704: AND responsibility_type = resp_type;
705:
706: BEGIN

Line 997: * Removed reference to hz_role_responsibility from cursor cust_role

993: /* R12 Changes
994: * p_cust_account_site_id is no longer null as we will start passing
995: * this value in as per OM
996: * Removed paramter p_acct_site_type and any references to it in the procedure
997: * Removed reference to hz_role_responsibility from cursor cust_role
998: * Removed reference to cursor cust_role_wo_party_site
999: */
1000: PROCEDURE get_cust_acct_roles(
1001: p_contact_party_id IN NUMBER,