APPS.HZ_IMP_DQM_STAGE dependencies on HZ_IMP_PARTIES_SG

Line 256: from hz_imp_parties_int a, hz_imp_parties_sg b

252: END IF;
253: -- - Update IDs on PARTY, CONTACTS, CONTACT_POINTS
254: log( ' Update party as same match rule being used');
255: update hz_srch_parties c set party_id = ( select b.party_id
256: from hz_imp_parties_int a, hz_imp_parties_sg b
257: where a.rowid = b.int_row_id
258: and c.int_row_id = a.rowid
259: and a.batch_id = p_batch_id
260: and a.batch_id = c.batch_id

Line 1987: l(' from hz_imp_parties_int a, hz_imp_parties_sg b ');

1983: END IF;
1984: l_sel_str := '';
1985: -- select a.organization_name, a.duns_number_c, a.tax_reference,
1986: -- a.party_orig_system, a.party_orig_system_reference, b.party_id
1987: l(' from hz_imp_parties_int a, hz_imp_parties_sg b ');
1988: l(' where b.action_flag = ''I''');
1989: l(' and b.int_row_id = a.rowid ');
1990: l(' and a.batch_id = p_batch_id ');
1991: l(' and b.party_orig_system_reference >= p_from_osr ');