APPS.JAI_OM_WSH_PKG dependencies on JAI_OM_OE_GEN_TAXINV_T

Line 709: DELETE from JAI_OM_OE_GEN_TAXINV_T statement got deleted in file version 615.5(Bug# 2736191) somehow. This statement is

705: adding this condition to the if which takes care of this issue.Also taken care of register type '23D_DOM_WITHOUT_EXCISE'
706: which was not handled till now.
707:
708: 25 2003/02/19 cbabu for Bug# 2803409, FileVersion# 615.7
709: DELETE from JAI_OM_OE_GEN_TAXINV_T statement got deleted in file version 615.5(Bug# 2736191) somehow. This statement is
710: reincorporated with his bug. Bugs 2736191 and 2769436 were made obsolete and this bug needs to be send instead of them
711:
712: 26. 2003/02/20 ssumaith - Bug # 2663211 File Version # 615.8
713: Excise invoice generation logic in this procedure has been removed and instead a call to the

Line 1200: FROM JAI_OM_OE_GEN_TAXINV_T ja_tmp

1196: Fnd_File.PUT_LINE(Fnd_File.LOG, ' 1 START Delivery id = ' || p_delivery_id );
1197: FOR Each_record IN
1198: (
1199: SELECT *
1200: FROM JAI_OM_OE_GEN_TAXINV_T ja_tmp
1201: WHERE delivery_id = p_delivery_id
1202: and /*The idea of putting the exists is to see that do not process a delivery ,if it has
1203: at least one delivery detail with inv_interfaced_flag = 'N' */
1204: not exists

Line 2454: DELETE JAI_OM_OE_GEN_TAXINV_T WHERE delivery_detail_id = each_record.delivery_detail_id;

2450: END IF; --y999
2451: -- cbabu for Bug# 2803409
2452: -- This statement got deleted with Bug# 2736191
2453: lv_statement_no := '61';
2454: DELETE JAI_OM_OE_GEN_TAXINV_T WHERE delivery_detail_id = each_record.delivery_detail_id;
2455:
2456: v_bonded_flag := 'N' ;
2457: v_trading_flag := 'N' ;
2458: v_rg23a_balance := 0 ;

Line 3039: From JAI_OM_OE_GEN_TAXINV_T joogtt,

3035: END IF ;
3036:
3037: ELSE
3038: FOR temp_rec IN ( Select distinct joogtt.delivery_id
3039: From JAI_OM_OE_GEN_TAXINV_T joogtt,
3040: jai_om_wsh_lines_all jowla
3041: where joogtt.delivery_id = jowla.delivery_id
3042: and mo_global.check_access(jowla.org_id) = 'Y'
3043: ) /*Added join of table jai_om_wsh_lines_all and check_access by mmurtuza for bug 16308603*/