DBA Data[Home] [Help]

APPS.ZX_PTP_IMPORT dependencies on ZX_REPORTING_CODES_B

Line 5864: FROM ZX_REPORTING_CODES_b RepCode

5860: WHERE (( reporting_code_id IS NOT NULL
5861: AND NOT EXISTS
5862: (
5863: SELECT 1
5864: FROM ZX_REPORTING_CODES_b RepCode
5865: WHERE RepCode.Reporting_Type_Id = rca_int.Reporting_Type_Id
5866: AND SYSDATE BETWEEN RepCode.EFFECTIVE_FROM
5867: AND NVL(RepCode.EFFECTIVE_TO,SYSDATE)
5868: AND reporting_code_id = rca_int.reporting_code_id

Line 5926: FROM ZX_REPORTING_CODES_B RepCode

5922: AND BITAND(error_number,G_ES_RCA_REP_TYPE_INVALID+
5923: G_ES_RCA_REP_CODE_INVALID) = 0
5924: AND NOT EXISTS (
5925: SELECT 1
5926: FROM ZX_REPORTING_CODES_B RepCode
5927: WHERE RepCode.Reporting_Type_Id = rca_int.Reporting_Type_Id
5928: AND RepCode.Reporting_Code_Id = rca_int.Reporting_Code_Id
5929: AND NVL(reporting_code_char_value, G_MISS_CHAR) =
5930: NVL(rca_int.reporting_code_char_value, G_MISS_CHAR)