APPS.JG_ZZ_VAT_SELECTION_PKG dependencies on ZX_REP_TRX_DETAIL_T

Line 1853: ZX_REP_TRX_DETAIL_T DET,

1849: EXT.ATTRIBUTE25 /* tax_origin*/ ,
1850: EXT.ATTRIBUTE26 /* Reporting Code */,
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

Line 2985: ZX_REP_TRX_DETAIL_T DET

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

Line 2992: DELETE from ZX_REP_TRX_DETAIL_T DET

2988: AND ACT.detail_tax_line_id = DET.detail_tax_line_id
2989: AND ACT.trx_arap_balancing_segment = p_global_variables_rec.BSV
2990: );
2991:
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

Line 3136: ZX_REP_TRX_DETAIL_T DET

3132: DET.trx_line_id,
3133: DET.tax_line_id
3134: FROM
3135: ZX_REP_CONTEXT_T CON,
3136: ZX_REP_TRX_DETAIL_T DET
3137: WHERE CON.request_id = x_request_id
3138: AND DET.request_id = CON.request_id
3139: AND DET.rep_context_id = CON.rep_context_id
3140: );