APPS.JAI_AR_SUP_TRX_PKG dependencies on JAI_AR_TRX_LINES

Line 168: FROM JAI_AR_TRX_LINES

164: -----------------------------------------------------------
165: AND NOT EXISTS
166: (
167: SELECT 1
168: FROM JAI_AR_TRX_LINES
169: WHERE CUSTOMER_TRX_ID = rcta.customer_trx_id
170: AND INTERFACE_FLAG = 'Y'
171: AND UPPER(INTERFACE_EVENT) = 'EXTERNAL'
172: )

Line 1019: FROM JAI_AR_TRX_LINES

1015: -- DISTINCT Key Word is not required, Vijay Shankar for bug # 3515883
1016: -- SELECT DISTINCT QUANTITY, TAX_CATEGORY_ID, ASSESSABLE_VALUE
1017: SELECT QUANTITY, TAX_CATEGORY_ID, ASSESSABLE_VALUE
1018: INTO AQUANTITY, ATAX_CATEGORY_ID, OLD_ASSESSABLE_VALUE
1019: FROM JAI_AR_TRX_LINES
1020: WHERE CUSTOMER_TRX_LINE_ID = I.CUSTOMER_TRX_LINE_ID;
1021: EXCEPTION
1022: WHEN OTHERS THEN
1023: NULL;

Line 1240: FROM JAI_AR_TRX_LINES

1236:
1237: v_statement_id := '26';
1238: SELECT UNIT_SELLING_PRICE
1239: INTO I_UNIT_SELLING_PRICE
1240: FROM JAI_AR_TRX_LINES
1241: WHERE CUSTOMER_TRX_LINE_ID = I.CUSTOMER_TRX_LINE_ID;
1242:
1243: OLD_INVOICE_AMOUNT := I_UNIT_SELLING_PRICE*AQUANTITY;
1244: