APPS.JG_ZZ_VAT_SELECTION_PKG dependencies on ZX_REP_ACTG_EXT_T

Line 1855: ZX_REP_ACTG_EXT_T ACT

1851: DET.DEF_REC_SETTLEMENT_OPTION_CODE /* Deferred Settlement Code*/
1852: FROM ZX_REP_CONTEXT_T CON,
1853: ZX_REP_TRX_DETAIL_T DET,
1854: ZX_REP_TRX_JX_EXT_T EXT,
1855: ZX_REP_ACTG_EXT_T ACT
1856: WHERE CON.REQUEST_ID = :request_id
1857: AND DET.REQUEST_ID = CON.REQUEST_ID
1858: AND DET.REP_CONTEXT_ID = CON.REP_CONTEXT_ID
1859: AND EXT.DETAIL_TAX_LINE_ID(+) = DET.DETAIL_TAX_LINE_ID

Line 2984: FROM ZX_REP_ACTG_EXT_T ACT,

2980: DELETE from ZX_REP_TRX_JX_EXT_T EXT
2981: WHERE EXT.request_id = x_request_id
2982: AND NOT EXISTS
2983: (SELECT 1
2984: FROM ZX_REP_ACTG_EXT_T ACT,
2985: ZX_REP_TRX_DETAIL_T DET
2986: WHERE DET.request_id = x_request_id
2987: AND EXT.detail_tax_line_id = DET.detail_tax_line_id
2988: AND ACT.detail_tax_line_id = DET.detail_tax_line_id

Line 2996: FROM ZX_REP_ACTG_EXT_T ACT

2992: DELETE from ZX_REP_TRX_DETAIL_T DET
2993: WHERE DET.request_id = x_request_id
2994: AND NOT EXISTS
2995: (SELECT 1
2996: FROM ZX_REP_ACTG_EXT_T ACT
2997: WHERE DET.request_id = x_request_id
2998: AND ACT.detail_tax_line_id = DET.detail_tax_line_id
2999: AND ACT.trx_arap_balancing_segment = p_global_variables_rec.BSV
3000: );

Line 3002: DELETE from ZX_REP_ACTG_EXT_T ACT

2998: AND ACT.detail_tax_line_id = DET.detail_tax_line_id
2999: AND ACT.trx_arap_balancing_segment = p_global_variables_rec.BSV
3000: );
3001:
3002: DELETE from ZX_REP_ACTG_EXT_T ACT
3003: WHERE ACT.request_id = x_request_id
3004: AND ACT.trx_arap_balancing_segment <> p_global_variables_rec.BSV;
3005:
3006: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN