APPS.HZ_MERGE_ENTITY_ATTRI_PVT dependencies on HZ_DUP_BATCH

Line 26: FROM HZ_PERSON_PROFILES PP,HZ_DUP_SETS DS, HZ_DUP_SET_PARTIES DSP, HZ_DUP_BATCH DB

22:
23: function get_healthCarePartyId(p_merge_batch_id in number) return number is
24: cursor get_healthCarePartyId_csr is
25: SELECT PP.PARTY_ID
26: FROM HZ_PERSON_PROFILES PP,HZ_DUP_SETS DS, HZ_DUP_SET_PARTIES DSP, HZ_DUP_BATCH DB
27: WHERE PP.PARTY_ID =DSP.DUP_PARTY_ID
28: AND DB.DUP_BATCH_ID = DS.DUP_BATCH_ID
29: AND DS.DUP_SET_ID = DSP.DUP_SET_ID
30: AND sysdate between pp.effective_start_date and nvl(pp.effective_end_date,sysdate)

Line 47: FROM HZ_PERSON_PROFILES PP,HZ_DUP_SETS DS, HZ_DUP_SET_PARTIES DSP, HZ_DUP_BATCH DB

43:
44: function get_InternalFlagPartyId(p_merge_batch_id in number,p_entity_name in VARCHAR2) return number is
45: cursor get_PPInternalFlagPartyId_csr is
46: SELECT PP.PARTY_ID
47: FROM HZ_PERSON_PROFILES PP,HZ_DUP_SETS DS, HZ_DUP_SET_PARTIES DSP, HZ_DUP_BATCH DB
48: WHERE PP.PARTY_ID =DSP.DUP_PARTY_ID
49: AND DB.DUP_BATCH_ID = DS.DUP_BATCH_ID
50: AND DS.DUP_SET_ID = DSP.DUP_SET_ID
51: AND sysdate between pp.effective_start_date and nvl(pp.effective_end_date,sysdate)

Line 58: FROM HZ_ORGANIZATION_PROFILES OP,HZ_DUP_SETS DS, HZ_DUP_SET_PARTIES DSP, HZ_DUP_BATCH DB

54: AND NVL(DSP.MERGE_FLAG,'Y') <> 'N'
55: AND ROWNUM = 1;
56: cursor get_OPInternalFlagPartyId_csr is
57: SELECT OP.PARTY_ID
58: FROM HZ_ORGANIZATION_PROFILES OP,HZ_DUP_SETS DS, HZ_DUP_SET_PARTIES DSP, HZ_DUP_BATCH DB
59: WHERE OP.PARTY_ID =DSP.DUP_PARTY_ID
60: AND DB.DUP_BATCH_ID = DS.DUP_BATCH_ID
61: AND DS.DUP_SET_ID = DSP.DUP_SET_ID
62: AND sysdate between op.effective_start_date and nvl(op.effective_end_date,sysdate)

Line 845: from hz_dup_batch db, hz_dup_sets ds

841: and attribute_name = 'BUSINESS_REPORT';
842:
843: cursor get_automerge_flag_csr is
844: select nvl(db.automerge_flag,'N')
845: from hz_dup_batch db, hz_dup_sets ds
846: where db.dup_batch_id = ds.dup_batch_id
847: and ds.dup_set_id = p_merge_batch_id
848: and rownum=1;
849:

Line 1467: ' from HZ_ORGANIZATION_PROFILES OP,HZ_PARTIES PARTY, HZ_DUP_SETS DS, HZ_DUP_SET_PARTIES DSP, HZ_DUP_BATCH DB '||

1463: then
1464: l_str := 'select party_id, decode('''||l_col_type||''',''D'',to_char(attri_value,''YYYY/MM/DD''),attri_value) from '||
1465: '(SELECT party_id, attri_value, rank() over (order by cntAttri desc) rank, '||l_date_clause || ' from '||
1466: '(SELECT OP.PARTY_ID, OP.'||l_col_name||' attri_value, count(*) over (partition by OP.'||l_col_name||') as cntAttri, '||'op.'||l_date_clause||
1467: ' from HZ_ORGANIZATION_PROFILES OP,HZ_PARTIES PARTY, HZ_DUP_SETS DS, HZ_DUP_SET_PARTIES DSP, HZ_DUP_BATCH DB '||
1468: 'WHERE OP.PARTY_ID =DSP.DUP_PARTY_ID AND DB.DUP_BATCH_ID = DS.DUP_BATCH_ID '||
1469: 'AND DS.DUP_SET_ID = DSP.DUP_SET_ID AND OP.PARTY_ID = PARTY.PARTY_ID '||
1470: 'AND sysdate between effective_start_date and nvl(effective_end_date,sysdate) '||
1471: 'AND OP.'||l_col_name||' is not null '||

Line 1481: ' from HZ_PERSON_PROFILES OP,HZ_PARTIES PARTY, HZ_DUP_SETS DS, HZ_DUP_SET_PARTIES DSP, HZ_DUP_BATCH DB '||

1477: else -- PERSON CASE
1478: l_str := 'select party_id, decode('''||l_col_type||''',''D'',to_char(attri_value,''YYYY/MM/DD''),attri_value) from '||
1479: '(SELECT party_id, attri_value, rank() over (order by cntAttri desc) rank, '||l_date_clause || ' from '||
1480: '(SELECT OP.PARTY_ID, OP.'||l_col_name||' attri_value, count(*) over (partition by OP.'||l_col_name||') as cntAttri, '||'op.'||l_date_clause||
1481: ' from HZ_PERSON_PROFILES OP,HZ_PARTIES PARTY, HZ_DUP_SETS DS, HZ_DUP_SET_PARTIES DSP, HZ_DUP_BATCH DB '||
1482: 'WHERE OP.PARTY_ID =DSP.DUP_PARTY_ID AND DB.DUP_BATCH_ID = DS.DUP_BATCH_ID '||
1483: 'AND DS.DUP_SET_ID = DSP.DUP_SET_ID AND OP.PARTY_ID = PARTY.PARTY_ID '||
1484: 'AND sysdate between effective_start_date and nvl(effective_end_date,sysdate) '||
1485: 'AND OP.'||l_col_name||' is not null '||