APPS.JL_BR_SPED_PKG dependencies on JL_BR_INTERFACE_LINES_EXTS

Line 285: JL_BR_INTERFACE_LINES_EXTS JLEXT

281: JLEXT.HEADER_GDF_ATTRIBUTE38,
282: JLEXT.HEADER_GDF_ATTRIBUTE39 --BUG 11825724
283: FROM RA_INTERFACE_LINES_ALL GT,
284: RA_CUSTOMER_TRX TRX,
285: JL_BR_INTERFACE_LINES_EXTS JLEXT
286: WHERE TRX.REQUEST_ID = P_REQUEST_ID
287: AND GT.CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID
288: AND GT.ROWID = JLEXT.JL_BR_INTERFACE_LINK_ID
289: AND GT.INTERFACE_LINE_ID = (SELECT MIN(GT_2.INTERFACE_LINE_ID)

Line 327: FROM JL_BR_INTERFACE_LINES_EXTS JLEXT,

323: JLEXT.LINE_GDF_ATTRIBUTE47,
324: JLEXT.LINE_GDF_ATTRIBUTE48,
325: JLEXT.LINE_GDF_ATTRIBUTE49,
326: JLEXT.LINE_GDF_ATTRIBUTE50
327: FROM JL_BR_INTERFACE_LINES_EXTS JLEXT,
328: RA_INTERFACE_LINES_ALL ARINT,
329: RA_CUSTOMER_TRX TRX
330: WHERE TRX.REQUEST_ID = P_REQUEST_ID
331: AND ARINT.CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID

Line 1410: DELETE FROM JL_BR_INTERFACE_LINES_EXTS

1406: AND INTERFACE_STATUS = 'P';
1407:
1408: FOR I IN 1..rowid_tab.COUNT
1409: LOOP
1410: DELETE FROM JL_BR_INTERFACE_LINES_EXTS
1411: WHERE JL_BR_INTERFACE_LINK_ID = rowid_tab(I);
1412: END LOOP;
1413:
1414: ELSE

Line 1415: DELETE FROM JL_BR_INTERFACE_LINES_EXTS

1411: WHERE JL_BR_INTERFACE_LINK_ID = rowid_tab(I);
1412: END LOOP;
1413:
1414: ELSE
1415: DELETE FROM JL_BR_INTERFACE_LINES_EXTS
1416: WHERE JL_BR_INTERFACE_LINK_ID IN (SELECT rowid FROM RA_INTERFACE_LINES
1417: WHERE INTERFACE_STATUS = 'P');
1418: END IF;
1419: