APPS.HZ_MATCH_RULE_58 dependencies on HZ_STAGED_CONTACT_POINTS

Line 1930: SELECT /*+ USE_NL(d stage) ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5

1926: END IF;
1927: IF p_restrict_entity = 'CONTACTS'
1928: THEN
1929: OPEN x_cursor FOR
1930: SELECT /*+ USE_NL(d stage) ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
1931: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1932: WHERE contains( concat_col, p_contains_str)>0
1933: AND d.search_context_id = p_search_ctx_id
1934: AND( (l_search_merged ='Y' )

Line 1931: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1927: IF p_restrict_entity = 'CONTACTS'
1928: THEN
1929: OPEN x_cursor FOR
1930: SELECT /*+ USE_NL(d stage) ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
1931: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1932: WHERE contains( concat_col, p_contains_str)>0
1933: AND d.search_context_id = p_search_ctx_id
1934: AND( (l_search_merged ='Y' )
1935: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1942: SELECT /*+ USE_NL(d stage) ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N3) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5

1938: END IF;
1939: IF p_restrict_entity = 'PARTY_SITES'
1940: THEN
1941: OPEN x_cursor FOR
1942: SELECT /*+ USE_NL(d stage) ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N3) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
1943: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1944: WHERE contains( concat_col, p_contains_str)>0
1945: AND d.search_context_id = p_search_ctx_id
1946: AND( (l_search_merged ='Y' )

Line 1943: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

1939: IF p_restrict_entity = 'PARTY_SITES'
1940: THEN
1941: OPEN x_cursor FOR
1942: SELECT /*+ USE_NL(d stage) ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N3) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
1943: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
1944: WHERE contains( concat_col, p_contains_str)>0
1945: AND d.search_context_id = p_search_ctx_id
1946: AND( (l_search_merged ='Y' )
1947: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1959: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5

1955: hz_utility_v2pub.debug(p_message=>'Single Party Scenario',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
1956: END IF;
1957: IF p_search_rel_cpts = 'N' THEN
1958: OPEN x_cursor FOR
1959: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
1960: FROM HZ_STAGED_CONTACT_POINTS stage
1961: WHERE contains( concat_col, p_contains_str)>0
1962: AND( (l_search_merged ='Y' )
1963: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1960: FROM HZ_STAGED_CONTACT_POINTS stage

1956: END IF;
1957: IF p_search_rel_cpts = 'N' THEN
1958: OPEN x_cursor FOR
1959: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
1960: FROM HZ_STAGED_CONTACT_POINTS stage
1961: WHERE contains( concat_col, p_contains_str)>0
1962: AND( (l_search_merged ='Y' )
1963: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1964: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1968: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5

1964: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1965: AND stage.party_id = p_party_id;
1966: ELSE
1967: OPEN x_cursor FOR
1968: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
1969: FROM HZ_STAGED_CONTACT_POINTS stage
1970: WHERE contains( concat_col, p_contains_str)>0
1971: AND( (l_search_merged ='Y' )
1972: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1969: FROM HZ_STAGED_CONTACT_POINTS stage

1965: AND stage.party_id = p_party_id;
1966: ELSE
1967: OPEN x_cursor FOR
1968: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
1969: FROM HZ_STAGED_CONTACT_POINTS stage
1970: WHERE contains( concat_col, p_contains_str)>0
1971: AND( (l_search_merged ='Y' )
1972: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1973: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )

Line 1976: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ stage.CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID , TX1, TX6, TX5

1972: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
1973: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1974: AND stage.party_id = p_party_id
1975: UNION
1976: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ stage.CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID , TX1, TX6, TX5
1977: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
1978: WHERE contains( concat_col, p_contains_str)>0
1979: AND r.object_id = p_party_id
1980: AND( (l_search_merged ='Y' )

Line 1977: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc

1973: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
1974: AND stage.party_id = p_party_id
1975: UNION
1976: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ stage.CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID , TX1, TX6, TX5
1977: FROM HZ_STAGED_CONTACT_POINTS stage, hz_relationships r, hz_org_contacts oc
1978: WHERE contains( concat_col, p_contains_str)>0
1979: AND r.object_id = p_party_id
1980: AND( (l_search_merged ='Y' )
1981: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))

Line 1999: FROM HZ_STAGED_CONTACT_POINTS stage

1995: hz_utility_v2pub.debug(p_message=>'Either Search context id is null',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
1996: END IF;
1997: OPEN x_cursor FOR
1998: SELECT CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
1999: FROM HZ_STAGED_CONTACT_POINTS stage
2000: WHERE contains( concat_col, p_contains_str)>0
2001: AND EXISTS (
2002: SELECT 1 FROM HZ_STAGED_PARTIES p
2003: WHERE p.PARTY_ID = stage.PARTY_ID

Line 2018: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5

2014: hz_utility_v2pub.debug(p_message=>'Search_context_id is not null',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2015: END IF;
2016: IF p_person_api = 'Y' THEN
2017: OPEN x_cursor FOR
2018: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
2019: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2020: WHERE contains( concat_col, p_contains_str)>0
2021: AND d.search_context_id = p_search_ctx_id
2022: AND d.party_id = stage.party_id

Line 2019: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2015: END IF;
2016: IF p_person_api = 'Y' THEN
2017: OPEN x_cursor FOR
2018: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
2019: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2020: WHERE contains( concat_col, p_contains_str)>0
2021: AND d.search_context_id = p_search_ctx_id
2022: AND d.party_id = stage.party_id
2023: AND( (l_search_merged ='Y' )

Line 2028: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, r.subject_id, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID , TX1, TX6, TX5

2024: OR (l_search_merged = 'I' AND nvl(stage.status_flag, 'A') in ('A', 'I'))
2025: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2026: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2027: UNION
2028: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, r.subject_id, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID , TX1, TX6, TX5
2029: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2030: WHERE contains( concat_col, p_contains_str)>0
2031: AND d.search_context_id = p_search_ctx_id
2032: AND d.party_id = r.subject_id

Line 2029: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage

2025: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2026: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id)
2027: UNION
2028: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, r.subject_id, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID , TX1, TX6, TX5
2029: FROM HZ_DQM_PARTIES_GT d, HZ_RELATIONSHIPS r, HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACT_POINTS stage
2030: WHERE contains( concat_col, p_contains_str)>0
2031: AND d.search_context_id = p_search_ctx_id
2032: AND d.party_id = r.subject_id
2033: AND r.relationship_id = oc.party_relationship_id

Line 2041: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5

2037: OR (l_search_merged = 'N' AND nvl(stage.status_flag, 'A') = 'A') )
2038: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2039: ELSE
2040: OPEN x_cursor FOR
2041: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
2042: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2043: WHERE contains( concat_col, p_contains_str)>0
2044: AND d.search_context_id = p_search_ctx_id
2045: AND d.party_id = stage.party_id

Line 2042: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage

2038: AND (p_dup_party_id IS NULL OR r.subject_id <> p_dup_party_id);
2039: ELSE
2040: OPEN x_cursor FOR
2041: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, stage.PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5
2042: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage
2043: WHERE contains( concat_col, p_contains_str)>0
2044: AND d.search_context_id = p_search_ctx_id
2045: AND d.party_id = stage.party_id
2046: AND( (l_search_merged ='Y' )

Line 2062: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_U1) */';

2058: IF (l_check_dt > 0 ) THEN
2059: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2060: hz_utility_v2pub.debug(p_message=>'Restrict Sql has the selective_cpt hint',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2061: END IF;
2062: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_U1) */';
2063: ELSIF (l_check > 0 ) THEN
2064: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2065: hz_utility_v2pub.debug(p_message=>'Restrict Sql has the selective hint',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2066: END IF;

Line 2067: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */';

2063: ELSIF (l_check > 0 ) THEN
2064: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2065: hz_utility_v2pub.debug(p_message=>'Restrict Sql has the selective hint',p_module_prefix=>'dqm',p_module=>'hz_match_rule_xxx',p_prefix=>NULL,p_msg_level=>fnd_log.level_statement);
2066: END IF;
2067: l_hint := '/*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */';
2068: END IF;
2069: IF l_search_merged = 'Y' THEN
2070: l_status_sql := ' ' ;
2071: ELSIF l_search_merged = 'I' THEN

Line 2086: l_sqlstr := ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||

2082: p_restrict_sql1 := replace( p_restrict_sql, 'stage.', 'stage1.');
2083: ELSE
2084: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2085: END IF;
2086: l_sqlstr := ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||
2087: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2088: ' WHERE contains( concat_col, :cont)>0 '||
2089: ' AND (stage.org_contact_id is null '||
2090: ' AND( ('''||l_search_merged||''' =''Y'' ) '||

Line 2087: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2083: ELSE
2084: p_restrict_sql1 := 'stage1.'||p_restrict_sql;
2085: END IF;
2086: l_sqlstr := ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||
2087: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2088: ' WHERE contains( concat_col, :cont)>0 '||
2089: ' AND (stage.org_contact_id is null '||
2090: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2091: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2096: ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||

2092: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||
2093: ' AND ('||p_restrict_sql||'))' ||
2094: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2095: ' UNION ' ||
2096: ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||
2097: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2098: ' WHERE contains( concat_col, :cont)>0 '||
2099: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2100: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||

Line 2097: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2093: ' AND ('||p_restrict_sql||'))' ||
2094: ' AND (:p_dup IS NULL OR stage.party_id <> :p_dup) ' ||
2095: ' UNION ' ||
2096: ' SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N2) */ CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||
2097: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2098: ' WHERE contains( concat_col, :cont)>0 '||
2099: ' AND( ('''||l_search_merged||''' =''Y'' ) '||
2100: ' OR ('''||l_search_merged||''' = ''I'' AND nvl(stage.status_flag, ''A'') in (''A'', ''I'')) '||
2101: ' OR ('''||l_search_merged||''' = ''N'' AND nvl(stage.status_flag, ''A'') = ''A'') ) '||

Line 2112: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2108: OPEN x_cursor FOR l_sqlstr USING p_contains_str,
2109: p_dup_party_id, p_dup_party_id, p_contains_str, p_dup_party_id, p_dup_party_id;
2110: ELSE
2111: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||
2112: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2113: ' WHERE contains( concat_col, :cont)>0'||
2114: ' AND EXISTS ('||
2115: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2116: ' WHERE p.party_id = stage.party_id ' ||

Line 2129: ' FROM HZ_STAGED_CONTACT_POINTS stage'||

2125: ,p_dup_party_id, p_dup_party_id;
2126: END IF;
2127: ELSE
2128: l_sqlstr := 'SELECT ' || l_hint ||' CONTACT_POINT_ID, stage.contact_point_type, PARTY_ID, PARTY_SITE_ID, ORG_CONTACT_ID , TX1, TX6, TX5'||
2129: ' FROM HZ_STAGED_CONTACT_POINTS stage'||
2130: ' WHERE contains( concat_col, :cont)>0'||
2131: ' AND EXISTS ('||
2132: ' SELECT 1 FROM HZ_STAGED_PARTIES p ' ||
2133: ' WHERE p.party_id = stage.party_id ' ||