APPS.JG_ZZ_VAT_SELECTION_PKG dependencies on ZX_REP_ACTG_EXT_T

Line 1952: ZX_REP_ACTG_EXT_T ACT

1948: EXT.ATTRIBUTE27 --- temporarily adding same attribute as reporting_code
1949: FROM ZX_REP_CONTEXT_T CON,
1950: ZX_REP_TRX_DETAIL_T DET,
1951: ZX_REP_TRX_JX_EXT_T EXT,
1952: ZX_REP_ACTG_EXT_T ACT
1953: WHERE CON.REQUEST_ID = :request_id
1954: AND DET.REQUEST_ID = CON.REQUEST_ID
1955: AND DET.REP_CONTEXT_ID = CON.REP_CONTEXT_ID
1956: AND EXT.DETAIL_TAX_LINE_ID(+) = DET.DETAIL_TAX_LINE_ID

Line 3100: FROM ZX_REP_ACTG_EXT_T ACT,

3096: DELETE from ZX_REP_TRX_JX_EXT_T EXT
3097: WHERE EXT.request_id = x_request_id
3098: AND NOT EXISTS
3099: (SELECT 1
3100: FROM ZX_REP_ACTG_EXT_T ACT,
3101: ZX_REP_TRX_DETAIL_T DET
3102: WHERE DET.request_id = x_request_id
3103: AND EXT.detail_tax_line_id = DET.detail_tax_line_id
3104: AND ACT.detail_tax_line_id = DET.detail_tax_line_id

Line 3112: FROM ZX_REP_ACTG_EXT_T ACT

3108: DELETE from ZX_REP_TRX_DETAIL_T DET
3109: WHERE DET.request_id = x_request_id
3110: AND NOT EXISTS
3111: (SELECT 1
3112: FROM ZX_REP_ACTG_EXT_T ACT
3113: WHERE DET.request_id = x_request_id
3114: AND ACT.detail_tax_line_id = DET.detail_tax_line_id
3115: AND ACT.trx_arap_balancing_segment = p_global_variables_rec.BSV
3116: );

Line 3118: DELETE from ZX_REP_ACTG_EXT_T ACT

3114: AND ACT.detail_tax_line_id = DET.detail_tax_line_id
3115: AND ACT.trx_arap_balancing_segment = p_global_variables_rec.BSV
3116: );
3117:
3118: DELETE from ZX_REP_ACTG_EXT_T ACT
3119: WHERE ACT.request_id = x_request_id
3120: AND ACT.trx_arap_balancing_segment <> p_global_variables_rec.BSV;
3121:
3122: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN