DBA Data[Home] [Help]

APPS.OE_OE_PRICING_AVAILABILITY dependencies on HZ_CUST_ACCOUNTS

Line 1706: FROM hz_parties p ,hz_cust_accounts c

1702: --
1703: BEGIN
1704: SELECT p.party_name,p.party_id
1705: INTO out_name,out_cust_id
1706: FROM hz_parties p ,hz_cust_accounts c
1707: WHERE p.party_id=c.party_id and c.cust_account_id = in_org_id;
1708:
1709: EXCEPTION
1710: WHEN OTHERS THEN

Line 1729: FROM hz_parties p ,hz_cust_accounts c

1725: --
1726: BEGIN
1727: SELECT p.party_name,c.ACCOUNT_NUMBER
1728: INTO out_name,out_cust_id
1729: FROM hz_parties p ,hz_cust_accounts c
1730: WHERE p.party_id=c.party_id and c.cust_account_id = in_org_id;
1731:
1732: EXCEPTION
1733: WHEN OTHERS THEN