DBA Data[Home] [Help]

APPS.ASO_APR_WF_PVT dependencies on HZ_CUST_ACCOUNTS

Line 4209: FROM hz_cust_accounts hca,

4205: CURSOR get_account_number (
4206: c_quote_header_id NUMBER
4207: ) IS
4208: SELECT hca.account_number
4209: FROM hz_cust_accounts hca,
4210: aso_quote_headers_all qha
4211: WHERE qha.cust_account_id = hca.cust_account_id(+)
4212: AND qha.quote_header_id = c_quote_header_id;
4213:

Line 5036: hz_cust_accounts hca

5032: ) IS
5033: SELECT hca.cust_account_id, hp.party_type
5034: FROM aso_quote_headers_all qha,
5035: hz_parties hp,
5036: hz_cust_accounts hca
5037: WHERE qha.quote_header_id = c_quote_header_id
5038: AND nvl(qha.cust_account_id,0 ) = hca.cust_account_id (+)
5039: AND qha.cust_party_id = hp.party_id;
5040: