APPS.CSI_ORDER_FULFILL_PUB dependencies on HZ_CUST_ACCT_SITES_ALL

Line 8819: FROM hz_cust_acct_sites_all c,

8815: l_cur_party_site_id := null;
8816:
8817: SELECT party_site_id
8818: INTO l_cur_party_site_id
8819: FROM hz_cust_acct_sites_all c,
8820: hz_cust_site_uses_all u
8821: WHERE c.cust_acct_site_id = u.cust_acct_site_id
8822: AND u.site_use_id = px_default_info_rec.current_party_site_id;
8823: */

Line 8854: FROM hz_cust_acct_sites_all c,

8850: l_inst_party_site_id := null;
8851:
8852: SELECT party_site_id
8853: INTO l_inst_party_site_id
8854: FROM hz_cust_acct_sites_all c,
8855: hz_cust_site_uses_all u
8856: WHERE c.cust_acct_site_id = u.cust_acct_site_id
8857: AND u.site_use_id = px_default_info_rec.install_party_site_id;
8858: */

Line 9358: hz_cust_acct_sites_all HCAS

9354: BEGIN
9355: SELECT HCAS.party_site_id
9356: INTO l_party_site_id
9357: FROM hz_cust_site_uses_all HCSU,
9358: hz_cust_acct_sites_all HCAS
9359: WHERE HCSU.site_use_id = l_current_site_use_id
9360: AND HCAS.cust_acct_site_id = HCSU.cust_acct_site_id;
9361: l_default_info_rec.current_party_site_id := l_party_site_id;
9362: EXCEPTION

Line 9377: hz_cust_acct_sites_all HCAS

9373: BEGIN
9374: SELECT HCAS.party_site_id
9375: INTO l_party_site_id
9376: FROM hz_cust_site_uses_all HCSU,
9377: hz_cust_acct_sites_all HCAS
9378: WHERE HCSU.site_use_id = l_install_site_use_id
9379: AND HCAS.cust_acct_site_id = HCSU.cust_acct_site_id;
9380: l_default_info_rec.install_party_site_id := l_party_site_id;
9381: EXCEPTION

Line 10617: FROM hz_cust_acct_sites_all c,

10613:
10614: BEGIN
10615: SELECT party_site_id
10616: INTO l_party_site_id
10617: FROM hz_cust_acct_sites_all c,
10618: hz_cust_site_uses_all u
10619: WHERE c.cust_acct_site_id = u.cust_acct_site_id
10620: AND u.site_use_id = x_order_shipment_tbl(i).ib_current_loc_id;
10621: EXCEPTION

Line 10643: FROM hz_cust_acct_sites_all c,

10639: THEN
10640: BEGIN
10641: SELECT party_site_id
10642: INTO l_install_party_site_id
10643: FROM hz_cust_acct_sites_all c,
10644: hz_cust_site_uses_all u
10645: WHERE c.cust_acct_site_id = u.cust_acct_site_id
10646: AND u.site_use_id = x_order_shipment_tbl(i).ib_install_loc_id;
10647: EXCEPTION