APPS.AR_DEPOSIT_LIB_PVT dependencies on HZ_CUST_ACCOUNTS

Line 590: from hz_cust_accounts

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

Line 633: from hz_cust_accounts

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

Line 710: from hz_cust_accounts

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

Line 752: from hz_cust_accounts

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

Line 859: FROM hz_cust_accounts c,

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

Line 873: FROM hz_cust_accounts cust_acct,

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

Line 1395: hz_cust_accounts.account_number%TYPE,

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

Line 1404: hz_cust_accounts.account_number%TYPE,

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

Line 1815: FROM hz_cust_accounts cust,

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

Line 1908: FROM hz_cust_accounts cust,

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

Line 2475: FROM hz_cust_accounts cust,

2471: +--------------------------------*/
2472: BEGIN
2473: SELECT cust.cust_account_id
2474: INTO l_customer_id
2475: FROM hz_cust_accounts cust,
2476: hz_customer_profiles cp,
2477: hz_parties party
2478: WHERE cust.cust_account_id = cp.cust_account_id (+) and
2479: cp.site_use_id is null and

Line 2563: FROM hz_cust_accounts cust,

2559: +--------------------------------*/
2560: BEGIN
2561: SELECT cust.cust_account_id
2562: INTO l_customer_id
2563: FROM hz_cust_accounts cust,
2564: hz_customer_profiles cp,
2565: hz_parties party
2566: WHERE cust.cust_account_id = cp.cust_account_id (+) and
2567: cp.site_use_id is null and