DBA Data[Home] [Help]

APPS.ZX_PTP_IMPORT dependencies on ZX_REPORTING_TYPES_VL

Line 5809: FROM Zx_Reporting_Types_VL RepType,

5805: AND reporting_type_name IS NOT NULL
5806: AND NOT EXISTS
5807: (
5808: SELECT 1
5809: FROM Zx_Reporting_Types_VL RepType,
5810: Zx_Report_Types_Usages RepUsage
5811: WHERE RepType.Reporting_Type_Id = RepUsage.Reporting_Type_Id
5812: AND RepUsage.Enabled_Flag= 'Y'
5813: AND SYSDATE BETWEEN RepType. EFFECTIVE_FROM

Line 5835: FROM Zx_Reporting_Types_VL RepType,

5831: UPDATE zx_report_codes_assoc_int rca_int
5832: SET reporting_type_id =
5833: (
5834: SELECT RepType.Reporting_Type_Id
5835: FROM Zx_Reporting_Types_VL RepType,
5836: Zx_Report_Types_Usages RepUsage
5837: WHERE RepType.Reporting_Type_Id = RepUsage.Reporting_Type_Id
5838: AND RepUsage.Enabled_Flag= 'Y'
5839: AND SYSDATE BETWEEN RepType. EFFECTIVE_FROM