APPS.ASO_APR_WF_PVT dependencies on HZ_CUST_ACCOUNTS

Line 4239: FROM hz_cust_accounts hca,

4235: CURSOR get_account_number (
4236: c_quote_header_id NUMBER
4237: ) IS
4238: SELECT hca.account_number
4239: FROM hz_cust_accounts hca,
4240: aso_quote_headers_all qha
4241: WHERE qha.cust_account_id = hca.cust_account_id(+)
4242: AND qha.quote_header_id = c_quote_header_id;
4243:

Line 5066: hz_cust_accounts hca

5062: ) IS
5063: SELECT hca.cust_account_id, hp.party_type
5064: FROM aso_quote_headers_all qha,
5065: hz_parties hp,
5066: hz_cust_accounts hca
5067: WHERE qha.quote_header_id = c_quote_header_id
5068: AND nvl(qha.cust_account_id,0 ) = hca.cust_account_id (+)
5069: AND qha.cust_party_id = hp.party_id;
5070: