APPS.HZ_IMP_LOAD_POST_PROCESS_PKG dependencies on HZ_PARTY_SITES

Line 450: FROM hz_locations l, hz_party_sites ps,

446: ,ps.party_site_id record_id
447: ,''PARTY_SITES'' entity
448: ,decode(addr_sg.action_flag, ''I'', ''C'', addr_sg.action_flag) operation_flag
449: ,null party_type
450: FROM hz_locations l, hz_party_sites ps,
451: hz_imp_addresses_sg addr_sg
452: WHERE l.request_id = :p_request_id
453: and l.location_id = ps.location_id
454: and addr_sg.batch_id = :p_batch_id

Line 471: FROM hz_locations l, hz_party_sites ps,

467: ,ps.party_site_id record_id
468: ,''PARTY_SITES'' entity
469: ,decode(addr_sg.action_flag, ''I'', ''C'', addr_sg.action_flag) operation_flag
470: ,null party_type
471: FROM hz_locations l, hz_party_sites ps,
472: hz_imp_addresses_sg addr_sg, hz_imp_batch_details bd
473: WHERE l.request_id = bd.main_conc_req_id
474: and bd.batch_id = addr_sg.batch_id
475: and l.location_id = ps.location_id

Line 709: hz_party_sites ps

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
713: AND site_sg.site_orig_system_reference between p_from_osr and p_to_osr

Line 790: hz_party_sites ps

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
794: and addr_sg.party_orig_system = p_os

Line 1019: FROM hz_party_sites

1015: CURSOR c_country (p_site_id IN NUMBER) IS
1016: SELECT country
1017: FROM hz_locations
1018: WHERE location_id = (SELECT location_id
1019: FROM hz_party_sites
1020: WHERE party_site_id = p_site_id);
1021:
1022: l1_country_code hz_phone_country_codes.territory_code%type;
1023: c_phone_format RefCurType;

Line 1074: ELSIF l_owner_table_name(i) = 'HZ_PARTY_SITES' AND

1070: EXCEPTION
1071: WHEN NO_DATA_FOUND THEN
1072: NULL;
1073: END;
1074: ELSIF l_owner_table_name(i) = 'HZ_PARTY_SITES' AND
1075: l_country_code(i) IS NULL
1076: THEN
1077: OPEN c_country(l_owner_table_id(i));
1078: FETCH c_country INTO l1_country_code;