[Home] [Help]
297: CLOSE c1;
298: IF (is_using_allow_cust_attr = 'Y') THEN
299: OPEN x_contact_cur FOR
300: select a.JOB_TITLE, a.obj_orig_system, a.obj_orig_system_reference, a.contact_orig_system, a.contact_orig_system_reference, b.party_action_flag, a.rowid, b.obj_id, c.person_first_name || ' ' || c.person_last_name as person_name
301: from HZ_IMP_CONTACTS_INT a, HZ_IMP_CONTACTS_SG b, HZ_IMP_PARTIES_INT c
302: where a.batch_id = p_batch_id
303: and b.action_flag = 'I'
304: and b.int_row_id = a.rowid
305: and a.sub_orig_system_reference >= p_from_osr
310: and b.batch_mode_flag = p_batch_mode_flag
311: and a.interface_status is null
312: union all
313: select a.JOB_TITLE, a.obj_orig_system, a.obj_orig_system_reference, a.contact_orig_system, a.contact_orig_system_reference, b.party_action_flag, a.rowid, b.obj_id, c.party_name as person_name
314: from HZ_IMP_CONTACTS_INT a, HZ_IMP_CONTACTS_SG b, hz_parties c
315: where a.batch_id = p_batch_id
316: and b.action_flag = 'I'
317: and b.int_row_id = a.rowid
318: and a.sub_orig_system_reference >= p_from_osr
323: ;
324: ELSE
325: OPEN x_contact_cur FOR
326: select a.JOB_TITLE, a.obj_orig_system, a.obj_orig_system_reference, a.contact_orig_system, a.contact_orig_system_reference, b.party_action_flag, a.rowid, b.obj_id
327: from HZ_IMP_CONTACTS_INT a, HZ_IMP_CONTACTS_SG b
328: where a.batch_id = p_batch_id
329: and b.action_flag = 'I'
330: and b.int_row_id = a.rowid
331: and a.sub_orig_system_reference >= p_from_osr