APPS.RLM_MESSAGE_SV dependencies on HZ_CUST_ACCT_SITES_ALL

Line 453: FROM hz_cust_acct_sites_all acct_site,

449: --C_DEBUG NUMBER :=rlm_core_sv.C_LEVEL6;
450: --
451: CURSOR c_GetShipTo IS
452: SELECT ece_tp_location_code
453: FROM hz_cust_acct_sites_all acct_site,
454: rlm_interface_lines_all lines
455: WHERE lines.ship_to_address_id = acct_site.cust_acct_site_id
456: AND lines.line_id = x_InterfaceLineId;
457: --

Line 460: FROM hz_cust_acct_sites_all acct_site,

456: AND lines.line_id = x_InterfaceLineId;
457: --
458: CURSOR c_GetBillTo IS
459: SELECT ece_tp_location_code
460: FROM hz_cust_acct_sites_all acct_site,
461: rlm_interface_lines_all lines
462: WHERE lines.bill_to_address_id = acct_site.cust_acct_site_id
463: AND lines.line_id = x_InterfaceLineId;
464: --

Line 467: FROM hz_cust_acct_sites_all acct_site,

463: AND lines.line_id = x_InterfaceLineId;
464: --
465: CURSOR c_GetIntrmdShipTo IS
466: SELECT ece_tp_location_code
467: FROM hz_cust_acct_sites_all acct_site,
468: rlm_interface_lines_all lines
469: WHERE lines.intrmd_ship_to_id = acct_site.cust_acct_site_id
470: AND lines.line_id = x_InterfaceLineId;
471: --