APPS.HZ_IMP_MATCH_RULE_52 dependencies on HZ_IMP_PARTIES_INT

Line 92: from hz_imp_parties_int a, hz_imp_parties_sg b

88: BEGIN
89: -- query for interface to TCA
90: open p_party_cur FOR
91: select decode(a.party_type, 'ORGANIZATION', a.organization_name, 'PERSON', a.person_first_name || ' ' || a.person_last_name) as PARTY_NAME , a.PARTY_TYPE, a.DUNS_NUMBER_C, a.JGZZ_FISCAL_CODE, a.party_orig_system, a.party_orig_system_reference, b.party_id, a.rowid, a.party_type
92: from hz_imp_parties_int a, hz_imp_parties_sg b
93: where b.action_flag = 'I'
94: and b.int_row_id = a.rowid
95: and a.batch_id = p_batch_id
96: and b.party_orig_system_reference >= p_from_osr

Line 302: from HZ_IMP_CONTACTS_INT a, HZ_IMP_CONTACTS_SG b, HZ_IMP_PARTIES_INT c

298: CLOSE c1;
299: IF (is_using_allow_cust_attr = 'Y') THEN
300: OPEN x_contact_cur FOR
301: 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
302: from HZ_IMP_CONTACTS_INT a, HZ_IMP_CONTACTS_SG b, HZ_IMP_PARTIES_INT c
303: where a.batch_id = p_batch_id
304: and b.action_flag = 'I'
305: and b.int_row_id = a.rowid
306: and a.sub_orig_system_reference >= p_from_osr

Line 405: from hz_imp_parties_int a

401: BEGIN
402: l_os := HZ_IMP_DQM_STAGE.get_os(p_batch_id);
403: open p_party_cur FOR
404: select decode(a.party_type, 'ORGANIZATION', a.organization_name, 'PERSON', a.person_first_name || ' ' || a.person_last_name) as PARTY_NAME , a.PARTY_TYPE, a.DUNS_NUMBER_C, a.JGZZ_FISCAL_CODE, a.party_orig_system, a.party_orig_system_reference, a.rowid, a.party_type , a.party_id
405: from hz_imp_parties_int a
406: where a.batch_id = p_batch_id
407: and a.party_orig_system_reference >= p_from_osr
408: and a.party_orig_system_reference <= p_to_osr
409: and a.party_orig_system = l_os;

Line 608: from HZ_IMP_CONTACTS_INT a, HZ_IMP_PARTIES_INT c

604: END LOOP;
605: IF (is_using_allow_cust_attr = 'Y') THEN
606: OPEN x_contact_cur FOR
607: select a.JOB_TITLE, a.obj_orig_system, a.obj_orig_system_reference, a.contact_orig_system, a.contact_orig_system_reference, a.rowid, c.person_first_name || ' ' || c.person_last_name as person_name
608: from HZ_IMP_CONTACTS_INT a, HZ_IMP_PARTIES_INT c
609: where a.batch_id = p_batch_id
610: and a.sub_orig_system_reference >= p_from_osr
611: and a.sub_orig_system_reference <= p_to_osr
612: and a.sub_orig_system_reference = c.party_orig_system_reference