APPS.PA_PAXPRCON_XMLP_PKG dependencies on HZ_CUST_ACCOUNTS

Line 294: hz_cust_accounts cust_acct

290: IF bill_to_customer_id IS NOT NULL THEN
291: select substr(party.party_name,1,50) into tmp_flag
292: from
293: hz_parties party,
294: hz_cust_accounts cust_acct
295: where
296: party.party_id = cust_acct.party_id
297: and cust_acct.cust_account_id = bill_to_customer_id;
298: RETURN tmp_flag;

Line 313: hz_cust_accounts cust_acct

309: IF ship_to_customer_id IS NOT NULL THEN
310: SELECT substrb(party.party_name,1,50) INTO tmp_flag
311: FROM
312: hz_parties party,
313: hz_cust_accounts cust_acct
314: WHERE
315: party.party_id = cust_acct.party_id
316: and cust_acct.cust_account_id = ship_to_customer_id;
317: RETURN tmp_flag;

Line 331: hz_cust_accounts cust_acct

327: IF bill_to_customer_id IS NOT NULL THEN
328: SELECT cust_acct.account_number INTO l_cust_no
329: FROM
330: hz_parties party,
331: hz_cust_accounts cust_acct
332: WHERE
333: party.party_id = cust_acct.party_id
334: and cust_acct.cust_account_id = bill_to_customer_id;
335: RETURN l_cust_no;

Line 349: hz_cust_accounts cust_acct

345: IF ship_to_customer_id IS NOT NULL THEN
346: SELECT cust_acct.account_number INTO l_cust_no
347: FROM
348: hz_parties party,
349: hz_cust_accounts cust_acct
350: WHERE
351: party.party_id = cust_acct.party_id
352: and cust_acct.cust_account_id = ship_to_customer_id;
353: RETURN l_cust_no;