APPS.ASO_WORKFLOW_PVT dependencies on HZ_CUST_ACCOUNTS

Line 318: Cursor c_hz_cust_accounts(p_cust_account_id NUMBER) IS

314: AND quote_line_id IS NULL
315: AND rownum = 1;
316:
317:
318: Cursor c_hz_cust_accounts(p_cust_account_id NUMBER) IS
319: SELECT hc.party_id,hp.Party_Name,hp.Person_First_Name,hp.Person_Middle_Name,hp.Person_Last_name,hp.party_type
320: FROM hz_cust_accounts hc, hz_parties hp
321: WHERE cust_account_id = p_cust_account_id
322: AND hc.party_id = hp.party_id;

Line 320: FROM hz_cust_accounts hc, hz_parties hp

316:
317:
318: Cursor c_hz_cust_accounts(p_cust_account_id NUMBER) IS
319: SELECT hc.party_id,hp.Party_Name,hp.Person_First_Name,hp.Person_Middle_Name,hp.Person_Last_name,hp.party_type
320: FROM hz_cust_accounts hc, hz_parties hp
321: WHERE cust_account_id = p_cust_account_id
322: AND hc.party_id = hp.party_id;
323:
324: l_sold_contact_party_id Number;

Line 377: FOR c_hz_cust_acct_rec IN c_hz_cust_accounts(g_quote_header_rec.cust_account_id) LOOP

373: END LOOP;
374:
375:
376: If l_sold_contact_party_id is null Then
377: FOR c_hz_cust_acct_rec IN c_hz_cust_accounts(g_quote_header_rec.cust_account_id) LOOP
378: l_contact_name := upper(rtrim(c_hz_cust_acct_rec.person_first_name))||' '||upper(rtrim(c_hz_cust_acct_rec.person_last_name));
379: l_sold_contact_party_id := c_hz_cust_acct_rec.party_id;
380: End Loop;
381: End If;

Line 418: 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)) LOOP

414:
415:
416: /* Bill Customer Info. From Invoice_To_Cust_Account_ID */
417:
418: 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)) LOOP
419: l_bill_to_party_name := rtrim(c_hz_cust_acct_rec.party_name);
420: l_bill_to_name := upper(rtrim(c_hz_cust_acct_rec.person_first_name))||' '||upper(rtrim(c_hz_cust_acct_rec.person_last_name));
421: l_bill_contact_party_id := c_hz_cust_acct_rec.party_id;
422: End Loop;

Line 511: 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)) LOOP

507: END IF;
508:
509: /* Shipping Customer Information - ship_to_cust_account_id */
510:
511: 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)) LOOP
512: l_ship_to_party_name := rtrim(c_hz_cust_acct_rec.party_name);
513: l_ship_to_name := upper(rtrim(c_hz_cust_acct_rec.person_first_name))||' '||upper(rtrim(c_hz_cust_acct_rec.person_last_name));
514: l_ship_contact_party_id := c_hz_cust_acct_rec.party_id;
515: End Loop;