APPS.OE_CUSTOMER_INFO_PVT dependencies on HZ_CUST_ACCOUNTS

Line 3107: from hz_cust_accounts

3103: BEGIN
3104:
3105: select party_id
3106: into l_party_id
3107: from hz_cust_accounts
3108: where cust_account_id = p_cust_acct_id;
3109:
3110: RETURN l_party_id;
3111:

Line 3199: FROM HZ_CUST_ACCOUNTS

3195:
3196: IF p_cust_account_id IS NOT NULL THEN
3197: SELECT OBJECT_VERSION_NUMBER
3198: into l_version_num
3199: FROM HZ_CUST_ACCOUNTS
3200: WHERE CUST_ACCOUNT_ID = p_cust_account_id;
3201: END IF;
3202:
3203: IF p_party_id IS NOT NULL THEN

Line 3894: HZ_CUST_ACCOUNTS ACCT,

3890: SELECT party.party_id,REL_PARTY.party_id
3891: into l_party_id , l_rel_party_id
3892: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
3893: HZ_PARTIES PARTY,
3894: HZ_CUST_ACCOUNTS ACCT,
3895: HZ_RELATIONSHIPS REL,
3896: HZ_ORG_CONTACTS ORG_CONT,
3897: HZ_PARTIES REL_PARTY
3898: WHERE ACCT_ROLE.PARTY_ID = REL.PARTY_ID