APPS.XTR_HEDGE_PROCESS_P dependencies on HZ_PARTIES

Line 1677: /* BUG 3497802 Repalcing RA_CUSTOMERS with HZ_PARTIES

1673: where batch_source_id = l_batch_source_id
1674: and org_id = l_ar_org_id;
1675:
1676:
1677: /* BUG 3497802 Repalcing RA_CUSTOMERS with HZ_PARTIES
1678:
1679: cursor customer(p_customer_id in number) is
1680: select customer_name
1681: from ra_customers

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 2146: /* BUG 3497802 Repalcing RA_CUSTOMERS with HZ_PARTIES

2142: select '(CUST_TRX_TYPE_ID = -99999) OR ' trxtype
2143: from DUAL
2144: where substr(fnd_message.get_string('XTR','XTR_AR_TRX_TYPE_CASH'),1,20) = p_trxtype;
2145:
2146: /* BUG 3497802 Repalcing RA_CUSTOMERS with HZ_PARTIES
2147:
2148: cursor ar_customer(p_customer in VARCHAR2) is
2149: SELECT CUSTOMER_ID ||',' customer
2150: FROM RA_CUSTOMERS

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);