APPS.AR_DEPOSIT_LIB_PVT dependencies on HZ_CUST_ACCOUNTS

Line 588: from hz_cust_accounts

584:
585: IF l_ship_via_ship_site_default IS NULL THEN
586: begin
587: select ship_via into l_ship_via_ship_default
588: from hz_cust_accounts
589: where cust_account_id = p_ship_to_customer_id;
590: exception
591: when no_data_found then
592: l_ship_via_ship_default := null;

Line 631: from hz_cust_accounts

627: IF l_ship_via_bill_site_default IS NULL THEN
628: begin
629: select ship_via
630: into l_ship_via_bill_default
631: from hz_cust_accounts
632: where cust_account_id = p_bill_to_customer_id;
633:
634: RETURN(l_ship_via_bill_default);
635: exception

Line 708: from hz_cust_accounts

704:
705: IF l_fob_ship_site_default IS NULL THEN
706: begin
707: select fob_point into l_fob_ship_default
708: from hz_cust_accounts
709: where cust_account_id = p_ship_to_customer_id;
710: exception
711: when no_data_found then
712: l_fob_ship_default := null;

Line 750: from hz_cust_accounts

746: IF l_fob_bill_site_default IS NULL THEN
747: begin
748: select fob_point
749: into l_fob_bill_default
750: from hz_cust_accounts
751: where cust_account_id = p_bill_to_customer_id;
752:
753: RETURN(l_fob_bill_default);
754: exception

Line 857: FROM hz_cust_accounts c,

853:
854:
855: SELECT c.cust_account_id
856: INTO l_selected_id
857: FROM hz_cust_accounts c,
858: hz_customer_profiles cp,
859: hz_parties party
860: WHERE c.cust_account_id = cp.cust_account_id (+) and
861: cp.site_use_id is null and

Line 871: FROM hz_cust_accounts cust_acct,

867: THEN
868:
869: SELECT cust_acct.cust_account_id
870: INTO l_selected_id
871: FROM hz_cust_accounts cust_acct,
872: hz_customer_profiles cp,
873: hz_parties party
874: WHERE cust_acct.cust_account_id = cp.cust_account_id (+)
875: and cust_acct.party_id = party.party_id(+)

Line 1393: hz_cust_accounts.account_number%TYPE,

1389: x_bill_to_customer_id IN OUT NOCOPY NUMBER,
1390: x_bill_to_customer_site_use_id IN OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
1391: p_bill_to_customer_name IN hz_parties.party_name%TYPE,
1392: p_bill_to_customer_number IN
1393: hz_cust_accounts.account_number%TYPE,
1394: p_bill_to_location IN OUT NOCOPY hz_cust_site_uses.location%type,
1395: x_bill_to_contact_id IN OUT NOCOPY NUMBER,
1396: p_bill_to_contact_first_name IN VARCHAR2,
1397: p_bill_to_contact_last_name IN VARCHAR2,

Line 1402: hz_cust_accounts.account_number%TYPE,

1398: x_ship_to_customer_id IN OUT NOCOPY NUMBER,
1399: x_ship_to_customer_site_use_id IN OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
1400: p_ship_to_customer_name IN hz_parties.party_name%TYPE,
1401: p_ship_to_customer_number IN
1402: hz_cust_accounts.account_number%TYPE,
1403: p_ship_to_location IN OUT NOCOPY hz_cust_site_uses.location%type,
1404: x_ship_to_contact_id IN OUT NOCOPY NUMBER,
1405: p_ship_to_contact_first_name IN VARCHAR2,
1406: p_ship_to_contact_last_name IN VARCHAR2,

Line 1813: FROM hz_cust_accounts cust,

1809: +--------------------------------*/
1810: BEGIN
1811: SELECT cust.cust_account_id
1812: INTO l_customer_id
1813: FROM hz_cust_accounts cust,
1814: hz_customer_profiles cp,
1815: hz_parties party
1816: WHERE cust.cust_account_id = cp.cust_account_id (+) and
1817: cp.site_use_id is null and

Line 1906: FROM hz_cust_accounts cust,

1902: +--------------------------------*/
1903: BEGIN
1904: SELECT cust.cust_account_id
1905: INTO l_customer_id
1906: FROM hz_cust_accounts cust,
1907: hz_customer_profiles cp,
1908: hz_parties party
1909: WHERE cust.cust_account_id = cp.cust_account_id (+) and
1910: cp.site_use_id is null and

Line 2449: FROM hz_cust_accounts cust,

2445: +--------------------------------*/
2446: BEGIN
2447: SELECT cust.cust_account_id
2448: INTO l_customer_id
2449: FROM hz_cust_accounts cust,
2450: hz_customer_profiles cp,
2451: hz_parties party
2452: WHERE cust.cust_account_id = cp.cust_account_id (+) and
2453: cp.site_use_id is null and

Line 2537: FROM hz_cust_accounts cust,

2533: +--------------------------------*/
2534: BEGIN
2535: SELECT cust.cust_account_id
2536: INTO l_customer_id
2537: FROM hz_cust_accounts cust,
2538: hz_customer_profiles cp,
2539: hz_parties party
2540: WHERE cust.cust_account_id = cp.cust_account_id (+) and
2541: cp.site_use_id is null and