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
862: c.account_number = p_value and
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(+)
876: and cp.site_use_id is null
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
1818: cust.cust_account_id = x_bill_to_customer_id and
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
1911: cust.cust_account_id = x_ship_to_customer_id and
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
2454: cust.cust_account_id = x_sold_to_customer_id and
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
2542: cust.cust_account_id = x_paying_customer_id and