DBA Data[Home] [Help]

APPS.OE_OE_PRICING_AVAILABILITY dependencies on HZ_CUST_ACCOUNTS

Line 1716: FROM hz_parties p ,hz_cust_accounts c

1712: --
1713: BEGIN
1714: SELECT p.party_name,p.party_id
1715: INTO out_name,out_cust_id
1716: FROM hz_parties p ,hz_cust_accounts c
1717: WHERE p.party_id=c.party_id and c.cust_account_id = in_org_id;
1718:
1719: EXCEPTION
1720: WHEN OTHERS THEN

Line 1739: FROM hz_parties p ,hz_cust_accounts c

1735: --
1736: BEGIN
1737: SELECT p.party_name,c.ACCOUNT_NUMBER
1738: INTO out_name,out_cust_id
1739: FROM hz_parties p ,hz_cust_accounts c
1740: WHERE p.party_id=c.party_id and c.cust_account_id = in_org_id;
1741:
1742: EXCEPTION
1743: WHEN OTHERS THEN