DBA Data[Home] [Help]

APPS.ZX_PTP_IMPORT dependencies on ZX_REPORT_TYPES_USAGES

Line 5792: Zx_Report_Types_Usages RepUsage

5788: AND NOT EXISTS
5789: (
5790: SELECT 1
5791: FROM Zx_Reporting_Types_b RepType,
5792: Zx_Report_Types_Usages RepUsage
5793: WHERE RepType.Reporting_Type_Id = RepUsage.Reporting_Type_Id
5794: AND RepUsage.Enabled_Flag= 'Y'
5795: AND SYSDATE BETWEEN RepType. EFFECTIVE_FROM
5796: AND NVL(RepType. EFFECTIVE_TO,SYSDATE)

Line 5810: Zx_Report_Types_Usages RepUsage

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
5814: AND NVL(RepType. EFFECTIVE_TO,SYSDATE)

Line 5836: Zx_Report_Types_Usages RepUsage

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
5840: AND NVL(RepType. EFFECTIVE_TO,SYSDATE)