APPS.HZ_ORIG_SYSTEM_REF_PVT dependencies on HZ_ORG_CONTACT_ROLES

Line 1981: --//Table hz_org_contact_roles

1977: and org.party_relationship_id = rel.relationship_id
1978: and rel.directional_flag = 'F';
1979: --and org.status = 'A'; -- Bug 3196803 : Removed the check of status = 'A'
1980:
1981: --//Table hz_org_contact_roles
1982: cursor c_org_cont_role_id is
1983: select rel.object_id
1984: from hz_org_contact_roles roles,hz_org_contacts org,hz_relationships rel
1985: where roles.org_contact_role_id = p_owner_table_id

Line 1984: from hz_org_contact_roles roles,hz_org_contacts org,hz_relationships rel

1980:
1981: --//Table hz_org_contact_roles
1982: cursor c_org_cont_role_id is
1983: select rel.object_id
1984: from hz_org_contact_roles roles,hz_org_contacts org,hz_relationships rel
1985: where roles.org_contact_role_id = p_owner_table_id
1986: and roles.org_contact_id = org.org_contact_id
1987: and org.party_relationship_id = rel.relationship_id
1988: and rel.directional_flag = 'F';

Line 2034: elsif p_owner_table_name = 'HZ_ORG_CONTACT_ROLES' then

2030: open c_org_cont_id;
2031: fetch c_org_cont_id into x_party_id;
2032: close c_org_cont_id;
2033:
2034: elsif p_owner_table_name = 'HZ_ORG_CONTACT_ROLES' then
2035: open c_org_cont_role_id;
2036: fetch c_org_cont_role_id into x_party_id;
2037: close c_org_cont_role_id;
2038: