APPS.HZ_ORIG_SYSTEM_REF_PVT dependencies on HZ_CUST_ACCOUNT_ROLES

Line 1991: --//Table hz_cust_account_roles

1987: and org.party_relationship_id = rel.relationship_id
1988: and rel.directional_flag = 'F';
1989: --and roles.status = 'A'; -- Bug 3196803 : Removed the check of status = 'A'
1990:
1991: --//Table hz_cust_account_roles
1992: cursor c_cust_acct_role_id is
1993: select cust.party_id
1994: from hz_cust_account_roles role,hz_cust_accounts cust
1995: where role.cust_account_role_id = p_owner_table_id

Line 1994: from hz_cust_account_roles role,hz_cust_accounts cust

1990:
1991: --//Table hz_cust_account_roles
1992: cursor c_cust_acct_role_id is
1993: select cust.party_id
1994: from hz_cust_account_roles role,hz_cust_accounts cust
1995: where role.cust_account_role_id = p_owner_table_id
1996: and role.cust_account_id = cust.cust_account_id;
1997: --and role.status = 'A'; -- Bug 3196803 : Removed the check of status = 'A'
1998:

Line 2039: elsif p_owner_table_name = 'HZ_CUST_ACCOUNT_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:
2039: elsif p_owner_table_name = 'HZ_CUST_ACCOUNT_ROLES' then
2040: open c_cust_acct_role_id;
2041: fetch c_cust_acct_role_id into x_party_id;
2042: close c_cust_acct_role_id;
2043: