APPS.JG_ZZ_VAT_SELECTION_PKG dependencies on ZX_REP_TRX_DETAIL_T

Line 1950: ZX_REP_TRX_DETAIL_T DET,

1946:
1947: -- BUG 9765740 Spanish Modelo 349 ESL EPL Changes
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

Line 3101: ZX_REP_TRX_DETAIL_T DET

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
3105: AND ACT.trx_arap_balancing_segment = p_global_variables_rec.BSV

Line 3108: DELETE from ZX_REP_TRX_DETAIL_T DET

3104: AND ACT.detail_tax_line_id = DET.detail_tax_line_id
3105: AND ACT.trx_arap_balancing_segment = p_global_variables_rec.BSV
3106: );
3107:
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

Line 3259: ZX_REP_TRX_DETAIL_T DET

3255: DET.trx_line_id,
3256: DET.tax_line_id
3257: FROM
3258: ZX_REP_CONTEXT_T CON,
3259: ZX_REP_TRX_DETAIL_T DET
3260: WHERE CON.request_id = x_request_id
3261: AND DET.request_id = CON.request_id
3262: AND DET.rep_context_id = CON.rep_context_id
3263: );

Line 3315: ZX_REP_TRX_DETAIL_T DET

3311: DET.trx_line_id,
3312: DET.tax_line_id
3313: FROM
3314: ZX_REP_CONTEXT_T CON,
3315: ZX_REP_TRX_DETAIL_T DET
3316: WHERE CON.request_id = x_request_id
3317: AND DET.request_id = CON.request_id
3318: AND DET.rep_context_id = CON.rep_context_id
3319: );