DBA Data[Home] [Help]

APPS.ZX_PTP_IMPORT dependencies on ZX_REPORTING_CODES_VL

Line 5877: FROM ZX_REPORTING_CODES_VL RepCode

5873: AND reporting_code_name IS NOT NULL
5874: AND NOT EXISTS
5875: (
5876: SELECT 1
5877: FROM ZX_REPORTING_CODES_VL RepCode
5878: WHERE RepCode.Reporting_Type_Id = rca_int.Reporting_Type_Id
5879: AND SYSDATE BETWEEN RepCode.EFFECTIVE_FROM
5880: AND NVL(RepCode.EFFECTIVE_TO,SYSDATE)
5881: AND reporting_code_name = rca_int.reporting_code_name

Line 5899: FROM ZX_REPORTING_CODES_VL RepCode

5895: UPDATE zx_report_codes_assoc_int rca_int
5896: SET reporting_code_id =
5897: (
5898: SELECT Reporting_Code_Id
5899: FROM ZX_REPORTING_CODES_VL RepCode
5900: WHERE RepCode.Reporting_Type_Id = rca_int.Reporting_Type_Id
5901: AND SYSDATE BETWEEN RepCode.EFFECTIVE_FROM
5902: AND NVL(RepCode.EFFECTIVE_TO,SYSDATE)
5903: AND RepCode.Reporting_Code_Name = rca_int.reporting_code_name