APPS.CSI_ORDER_FULFILL_PUB dependencies on HZ_CUST_ACCT_SITES_ALL

Line 8437: hz_cust_acct_sites_all HCAS

8433: BEGIN
8434: SELECT HCAS.party_site_id
8435: INTO l_party_site_id
8436: FROM hz_cust_site_uses_all HCSU,
8437: hz_cust_acct_sites_all HCAS
8438: WHERE HCSU.site_use_id = l_current_site_use_id
8439: AND HCAS.cust_acct_site_id = HCSU.cust_acct_site_id;
8440: l_default_info_rec.current_party_site_id := l_party_site_id;
8441: EXCEPTION

Line 8456: hz_cust_acct_sites_all HCAS

8452: BEGIN
8453: SELECT HCAS.party_site_id
8454: INTO l_party_site_id
8455: FROM hz_cust_site_uses_all HCSU,
8456: hz_cust_acct_sites_all HCAS
8457: WHERE HCSU.site_use_id = l_install_site_use_id
8458: AND HCAS.cust_acct_site_id = HCSU.cust_acct_site_id;
8459: l_default_info_rec.install_party_site_id := l_party_site_id;
8460: EXCEPTION

Line 9601: FROM hz_cust_acct_sites_all c,

9597:
9598: BEGIN
9599: SELECT party_site_id
9600: INTO l_party_site_id
9601: FROM hz_cust_acct_sites_all c,
9602: hz_cust_site_uses_all u
9603: WHERE c.cust_acct_site_id = u.cust_acct_site_id
9604: AND u.site_use_id = x_order_shipment_tbl(i).ib_current_loc_id;
9605: EXCEPTION

Line 9627: FROM hz_cust_acct_sites_all c,

9623: THEN
9624: BEGIN
9625: SELECT party_site_id
9626: INTO l_install_party_site_id
9627: FROM hz_cust_acct_sites_all c,
9628: hz_cust_site_uses_all u
9629: WHERE c.cust_acct_site_id = u.cust_acct_site_id
9630: AND u.site_use_id = x_order_shipment_tbl(i).ib_install_loc_id;
9631: EXCEPTION