APPS.HZ_PARTY_SEARCH_BO_PUB dependencies on HZ_ORIG_SYS_REFERENCES

Line 90: FROM HZ_ORIG_SYS_REFERENCES OSR

86: ATTRIBUTE17,
87: ATTRIBUTE18,
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

Line 159: FROM HZ_ORIG_SYS_REFERENCES OSR

155: ATTRIBUTE17,
156: ATTRIBUTE18,
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)

Line 181: l_within_sql := ' EXISTS (SELECT 1 FROM hz_orig_sys_references o

177: END IF;
178:
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: