APPS.HZ_ORIG_SYSTEM_REF_PVT dependencies on HZ_CUST_ACCOUNT_ROLES

Line 2038: --//Table hz_cust_account_roles

2034: and org.party_relationship_id = rel.relationship_id
2035: and rel.directional_flag = 'F';
2036: --and roles.status = 'A'; -- Bug 3196803 : Removed the check of status = 'A'
2037:
2038: --//Table hz_cust_account_roles
2039: cursor c_cust_acct_role_id is
2040: select cust.party_id
2041: from hz_cust_account_roles role,hz_cust_accounts cust
2042: where role.cust_account_role_id = p_owner_table_id

Line 2041: from hz_cust_account_roles role,hz_cust_accounts cust

2037:
2038: --//Table hz_cust_account_roles
2039: cursor c_cust_acct_role_id is
2040: select cust.party_id
2041: from hz_cust_account_roles role,hz_cust_accounts cust
2042: where role.cust_account_role_id = p_owner_table_id
2043: and role.cust_account_id = cust.cust_account_id;
2044: --and role.status = 'A'; -- Bug 3196803 : Removed the check of status = 'A'
2045:

Line 2086: elsif p_owner_table_name = 'HZ_CUST_ACCOUNT_ROLES' then

2082: open c_org_cont_role_id;
2083: fetch c_org_cont_role_id into x_party_id;
2084: close c_org_cont_role_id;
2085:
2086: elsif p_owner_table_name = 'HZ_CUST_ACCOUNT_ROLES' then
2087: open c_cust_acct_role_id;
2088: fetch c_cust_acct_role_id into x_party_id;
2089: close c_cust_acct_role_id;
2090: