APPS.HZ_PARTY_SEARCH_BO_PUB dependencies on HZ_PARTIES

Line 92: AND OWNER_TABLE_NAME = 'HZ_PARTIES'

88: ATTRIBUTE19,
89: ATTRIBUTE20)
90: FROM HZ_ORIG_SYS_REFERENCES OSR
91: WHERE OSR.OWNER_TABLE_ID = HZP.PARTY_ID
92: AND OWNER_TABLE_NAME = 'HZ_PARTIES'
93: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL)
94: ) AS HZ_MATCHED_PARTY_OBJ_TBL
95: FROM hz_matched_parties_gt mpgt, hz_parties hzp
96: WHERE mpgt.party_id = hzp.party_id

Line 95: FROM hz_matched_parties_gt mpgt, hz_parties hzp

91: WHERE OSR.OWNER_TABLE_ID = HZP.PARTY_ID
92: AND OWNER_TABLE_NAME = 'HZ_PARTIES'
93: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL)
94: ) AS HZ_MATCHED_PARTY_OBJ_TBL
95: FROM hz_matched_parties_gt mpgt, hz_parties hzp
96: WHERE mpgt.party_id = hzp.party_id
97: AND mpgt.search_context_id = l_search_ctx_id;
98:
99: -- Cursor to select all the matching parties with 'within' clause

Line 161: AND OWNER_TABLE_NAME = 'HZ_PARTIES'

157: ATTRIBUTE19,
158: ATTRIBUTE20)
159: FROM HZ_ORIG_SYS_REFERENCES OSR
160: WHERE OSR.OWNER_TABLE_ID = HZP.PARTY_ID
161: AND OWNER_TABLE_NAME = 'HZ_PARTIES'
162: AND OSR.ORIG_SYSTEM = l_within_os
163: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL)
164: ) AS HZ_MATCHED_PARTY_OBJ_TBL
165: FROM hz_matched_parties_gt mpgt, hz_parties hzp

Line 165: FROM hz_matched_parties_gt mpgt, hz_parties hzp

161: AND OWNER_TABLE_NAME = 'HZ_PARTIES'
162: AND OSR.ORIG_SYSTEM = l_within_os
163: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL)
164: ) AS HZ_MATCHED_PARTY_OBJ_TBL
165: FROM hz_matched_parties_gt mpgt, hz_parties hzp
166: WHERE mpgt.party_id = hzp.party_id
167: AND mpgt.search_context_id = l_search_ctx_id;
168:
169: BEGIN

Line 183: AND o.owner_table_name = ''HZ_PARTIES''

179: -- Check if the 'p_within_os' parameter passed has a value
180: IF p_within_os IS NOT NULL THEN
181: l_within_sql := ' EXISTS (SELECT 1 FROM hz_orig_sys_references o
182: WHERE o.orig_system = '''||p_within_os||'''
183: AND o.owner_table_name = ''HZ_PARTIES''
184: AND o.owner_table_id = stage.party_id)';
185:
186: -- If restrict sql has a value
187: IF p_restrict_sql IS NOT NULL THEN