[Home] [Help]
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
864: c.account_number = p_value and
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(+)
878: and cp.site_use_id is null
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
1820: cust.cust_account_id = x_bill_to_customer_id and
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
1913: cust.cust_account_id = x_ship_to_customer_id and
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
2480: cust.cust_account_id = x_sold_to_customer_id and
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
2568: cust.cust_account_id = x_paying_customer_id and