APPS.XTR_HEDGE_PROCESS_P dependencies on HZ_CUST_ACCOUNTS

Line 1688: from hz_parties party, hz_cust_accounts cust_acct

1684: */
1685:
1686: cursor customer(p_customer_id in number) is
1687: select substrb(PARTY.PARTY_NAME,1,50)
1688: from hz_parties party, hz_cust_accounts cust_acct
1689: where cust_acct.party_id = party.party_id
1690: and cust_acct.cust_account_id = p_customer_id;
1691:
1692: cursor ar_org is

Line 2157: FROM hz_parties party, hz_cust_accounts cust_acct

2153: */
2154:
2155: cursor ar_customer(p_customer in VARCHAR2) is
2156: SELECT cust_acct.cust_account_id||',' customer
2157: FROM hz_parties party, hz_cust_accounts cust_acct
2158: WHERE substrb(PARTY.PARTY_NAME,1,50) = p_customer
2159: and cust_acct.party_id = party.party_id;
2160:
2161: l_ar_customer_eq VARCHAR2(5000);