APPS.CSI_INTERFACE_PKG dependencies on HZ_CUST_ACCT_SITES_ALL

Line 2920: hz_cust_acct_sites_all hcas

2916: THEN
2917: SELECT hcas.party_site_id
2918: INTO x_source_line_rec.ship_to_party_site_id
2919: FROM hz_cust_site_uses_all hcsu,
2920: hz_cust_acct_sites_all hcas
2921: WHERE hcsu.site_use_id = x_source_line_rec.ib_current_loc_id -- ship_to_address_id
2922: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id;
2923: END IF;
2924:

Line 2933: hz_cust_acct_sites_all hcas

2929: THEN
2930: SELECT hcas.party_site_id
2931: INTO x_source_line_rec.install_to_party_site_id
2932: FROM hz_cust_site_uses_all hcsu,
2933: hz_cust_acct_sites_all hcas
2934: WHERE hcsu.site_use_id = x_source_line_rec.ib_install_loc_id
2935: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id;
2936: END IF;
2937:

Line 3048: hz_cust_acct_sites_all hcas

3044: IF x_source_line_rec.ship_to_address_id is not null THEN
3045: SELECT hcas.party_site_id
3046: INTO x_source_line_rec.ship_to_party_site_id
3047: FROM hz_cust_site_uses_all hcsu,
3048: hz_cust_acct_sites_all hcas
3049: WHERE hcsu.site_use_id = x_source_line_rec.ship_to_address_id
3050: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id;
3051: END IF;
3052: