DBA Data[Home] [Help]

APPS.ZX_PRD_OPTIONS_MIGRATE_PKG dependencies on ZX_EVNT_CLS_MAPPINGS

Line 1184: ZX_EVNT_CLS_MAPPINGS mapp

1180: prd.last_update_date,
1181: prd.last_updated_by,
1182: prd.last_update_login
1183: FROM ZX_PRODUCT_OPTIONS_ALL prd,
1184: ZX_EVNT_CLS_MAPPINGS mapp
1185: WHERE prd.application_id = 200
1186: AND prd.event_class_mapping_id is null
1187: AND mapp.application_id = prd.application_id
1188: AND mapp.entity_code = 'AP_INVOICES'

Line 1195: FROM zx_evnt_cls_mappings

1191: FROM ZX_PRODUCT_OPTIONS_ALL prd1
1192: WHERE prd1.ORG_ID = decode(l_multi_org_flag,'N',l_org_id,prd.org_id)
1193: AND prd1.APPLICATION_ID = 200
1194: AND prd1.event_class_mapping_id = (SELECT event_class_mapping_id
1195: FROM zx_evnt_cls_mappings
1196: WHERE application_id = 200
1197: AND entity_code = 'AP_INVOICES'
1198: AND event_class_code = 'EXPENSE REPORTS')
1199: );