DBA Data[Home] [Help]

APPS.HZ_IMP_LOAD_POST_PROCESS_PKG dependencies on HZ_IMP_ADDRESSES_INT

Line 708: hz_imp_addresses_int site_int,

704: p_to_osr IN VARCHAR2
705: ) IS
706: CURSOR c_loc IS SELECT ps.location_id,ps.created_by_module,site_sg.site_orig_system_reference
707: FROM hz_imp_addresses_sg site_sg,
708: hz_imp_addresses_int site_int,
709: hz_party_sites ps
710: WHERE site_sg.batch_id = p_batch_id
711: AND site_sg.batch_mode_flag = p_batch_mode_flag
712: AND site_sg.site_orig_system = p_os

Line 789: from hz_locations l,hz_imp_addresses_int addr_int, hz_imp_addresses_sg addr_sg,

785: l_msg_data VARCHAR2(2000);
786:
787: cursor c_timezone_loc is
788: select l.location_id, l.country, l.state, l.city, l.postal_code
789: from hz_locations l,hz_imp_addresses_int addr_int, hz_imp_addresses_sg addr_sg,
790: hz_party_sites ps
791: where l.location_id = ps.location_id
792: and addr_sg.batch_id = p_batch_id
793: and addr_sg.batch_mode_flag = p_batch_mode_flag