APPS.CSI_UTL_PKG dependencies on HZ_CUST_ACCT_SITES_ALL

Line 871: FROM hz_cust_acct_sites_all c,

867:
868: BEGIN
869: SELECT party_site_id
870: INTO l_party_site_id
871: FROM hz_cust_acct_sites_all c,
872: hz_cust_site_uses_all u
873: WHERE c.cust_acct_site_id = u.cust_acct_site_id
874: AND u.site_use_id = p_order_shipment_rec.ib_current_loc_id; -- ship_to_org_id;
875: EXCEPTION

Line 897: FROM hz_cust_acct_sites_all c,

893: Then
894: BEGIN
895: SELECT party_site_id
896: INTO l_install_party_site_id
897: FROM hz_cust_acct_sites_all c,
898: hz_cust_site_uses_all u
899: WHERE c.cust_acct_site_id = u.cust_acct_site_id
900: AND u.site_use_id = p_order_shipment_rec.ib_install_loc_id; -- ship_to_org_id;
901: Exception

Line 1070: FROM hz_cust_acct_sites_all c,

1066:
1067: BEGIN
1068: SELECT party_site_id
1069: INTO l_party_site_id
1070: FROM hz_cust_acct_sites_all c,
1071: hz_cust_site_uses_all u
1072: WHERE c.cust_acct_site_id = u.cust_acct_site_id
1073: AND u.site_use_id = p_order_shipment_rec.ship_to_org_id;
1074: EXCEPTION

Line 1659: FROM hz_cust_acct_sites_all hzcas,

1655: p_org_id => l_order_line_rec.org_id);
1656: BEGIN
1657: SELECT party_site_id
1658: INTO l_order_line_rec.ship_to_party_site_id
1659: FROM hz_cust_acct_sites_all hzcas,
1660: hz_cust_site_uses_all hzcsu
1661: WHERE hzcsu.site_use_id = l_order_line_rec.ship_to_org_id
1662: AND hzcas.cust_acct_site_id = hzcsu.cust_acct_site_id;
1663: EXCEPTION