APPS.ZX_EVNT_OPTIONS_MIGRATE_PKG dependencies on ZX_EVNT_CLS_MAPPINGS

Line 110: ZX_EVNT_CLS_MAPPINGS mapping

106: ptp.LAST_UPDATE_LOGIN
107: FROM ZX_PARTY_TAX_PROFILE ptp,
108: AP_SYSTEM_PARAMETERS_ALL sys,
109: -- AP_TOLERANCE_TEMPLATES tol, --Bug 5117926
110: ZX_EVNT_CLS_MAPPINGS mapping
111: WHERE mapping.application_id = 200
112: AND decode(l_multi_org_flag,'N',l_org_id,sys.org_id) = ptp.party_id
113: -- AND sys.tolerance_id = tol.tolerance_id(+) -- Bug 5232304 --Bug 5117926
114: AND ptp.PARTY_TYPE_CODE ='OU'

Line 237: ZX_EVNT_CLS_MAPPINGS mapping

233: ptp.LAST_UPDATED_BY,
234: ptp.LAST_UPDATE_LOGIN
235: FROM ZX_PARTY_TAX_PROFILE ptp,
236: AR_SYSTEM_PARAMETERS_ALL sys,
237: ZX_EVNT_CLS_MAPPINGS mapping
238: WHERE mapping.application_id = 222
239: AND decode(l_multi_org_flag,'N',l_org_id,sys.org_id) = ptp.party_id
240: AND ptp.PARTY_TYPE_CODE ='OU'
241: AND ptp.record_type_code='MIGRATED'

Line 359: ZX_EVNT_CLS_MAPPINGS mapping

355: ptp.LAST_UPDATE_LOGIN
356: FROM ZX_PARTY_TAX_PROFILE ptp,
357: PO_SYSTEM_PARAMETERS_ALL syspo,
358: AP_SYSTEM_PARAMETERS_ALL sysap,
359: ZX_EVNT_CLS_MAPPINGS mapping
360: WHERE mapping.application_id = 201
361: AND decode(l_multi_org_flag,'N',l_org_id,syspo.org_id) = ptp.party_id
362: AND decode(l_multi_org_flag,'N',l_org_id,syspo.org_id) = decode(l_multi_org_flag,'N',l_org_id,sysap.org_id(+))
363: AND ptp.PARTY_TYPE_CODE ='OU'