APPS.ASO_WORKFLOW_QUOTE_PVT dependencies on HZ_CUST_ACCOUNTS

Line 437: Cursor c_hz_cust_accounts(p_cust_account_id NUMBER) IS

433: AND quote_line_id IS NULL
434: AND rownum = 1;
435:
436:
437: Cursor c_hz_cust_accounts(p_cust_account_id NUMBER) IS
438: SELECT hc.party_id,hp.Party_Name,hp.Person_First_Name,hp.Person_Middle_Name,hp.Person_Last_name,hp.party_type
439: FROM hz_cust_accounts hc, hz_parties hp
440: WHERE cust_account_id = p_cust_account_id
441: AND hc.party_id = hp.party_id;

Line 439: FROM hz_cust_accounts hc, hz_parties hp

435:
436:
437: Cursor c_hz_cust_accounts(p_cust_account_id NUMBER) IS
438: SELECT hc.party_id,hp.Party_Name,hp.Person_First_Name,hp.Person_Middle_Name,hp.Person_Last_name,hp.party_type
439: FROM hz_cust_accounts hc, hz_parties hp
440: WHERE cust_account_id = p_cust_account_id
441: AND hc.party_id = hp.party_id;
442:
443: Cursor c_ship_methods(pCode Varchar2) IS

Line 532: FOR c_hz_cust_acct_rec IN c_hz_cust_accounts(g_quote_header_rec.cust_account_id)

528: END LOOP;
529:
530: IF l_sold_contact_party_id is NULL
531: THEN
532: FOR c_hz_cust_acct_rec IN c_hz_cust_accounts(g_quote_header_rec.cust_account_id)
533: LOOP
534: l_contact_name := upper(rtrim(c_hz_cust_acct_rec.person_first_name))||' '||upper(rtrim(c_hz_cust_acct_rec.person_last_name));
535: l_sold_contact_party_id := c_hz_cust_acct_rec.party_id;
536: END LOOP;

Line 573: FOR c_hz_cust_acct_rec IN c_hz_cust_accounts(nvl(g_quote_header_rec.invoice_to_cust_account_id,g_quote_header_rec.cust_account_id))

569:
570:
571: /* Bill Customer Info. From Invoice_To_Cust_Account_ID */
572:
573: FOR c_hz_cust_acct_rec IN c_hz_cust_accounts(nvl(g_quote_header_rec.invoice_to_cust_account_id,g_quote_header_rec.cust_account_id))
574: LOOP
575: l_bill_to_party_name := rtrim(c_hz_cust_acct_rec.party_name);
576: l_bill_to_name := upper(rtrim(c_hz_cust_acct_rec.person_first_name))||' '||upper(rtrim(c_hz_cust_acct_rec.person_last_name));
577: l_bill_contact_party_id := c_hz_cust_acct_rec.party_id;

Line 671: FOR c_hz_cust_acct_rec IN c_hz_cust_accounts(nvl(l_ship_to_cust_account_id,g_quote_header_rec.cust_account_id))

667: END IF;
668:
669: /* Shipping Customer Information - ship_to_cust_account_id */
670:
671: FOR c_hz_cust_acct_rec IN c_hz_cust_accounts(nvl(l_ship_to_cust_account_id,g_quote_header_rec.cust_account_id))
672: LOOP
673: l_ship_to_party_name := rtrim(c_hz_cust_acct_rec.party_name);
674: l_ship_to_name := upper(rtrim(c_hz_cust_acct_rec.person_first_name))||' '||upper(rtrim(c_hz_cust_acct_rec.person_last_name));
675: l_ship_contact_party_id := c_hz_cust_acct_rec.party_id;