APPS.JAI_JAR_TRXS_TRIGGER_PKG dependencies on JAI_AR_TRX_INS_HDRS_T

Line 98: From JAI_AR_TRX_INS_HDRS_T

94: Select SHIP_TO_CUSTOMER_ID,SHIP_TO_SITE_USE_ID,CUST_TRX_TYPE_ID,
95: TRX_DATE,SOLD_TO_CUSTOMER_ID,
96: BATCH_SOURCE_ID,
97: BILL_TO_CUSTOMER_ID, BILL_TO_SITE_USE_ID --2001/05/04 Vijay,Subbu.
98: From JAI_AR_TRX_INS_HDRS_T
99: Where customer_trx_id = v_customer_trx_id;
100:
101: --2001/06/22 Anuradha Parthasarathy
102: /*Cursor org_loc_cur IS

Line 162: FROM JAI_AR_TRX_INS_HDRS_T

158: where inventory_item_id = p_inventory_item_id AND
159: ORGANIZATION_ID = P_ORG_ID;
160: cursor organization_cur IS
161: select organization_id,location_id
162: FROM JAI_AR_TRX_INS_HDRS_T
163: WHERE customer_trx_id = v_customer_trx_id;
164: CURSOR fin_year_cur(p_org_id IN NUMBER) IS
165: SELECT MAX(a.fin_year)
166: FROM JAI_CMN_FIN_YEARS a

Line 277: FROM jai_ar_trx_ins_hdrs_t

273: AND intfs.taxable_event = 'EXTERNAL';
274:
275: CURSOR get_trx_date_cur IS
276: SELECT trx_date
277: FROM jai_ar_trx_ins_hdrs_t
278: WHERE customer_trx_id = v_customer_trx_id;
279:
280: CURSOR get_open_source_cur IS
281: SELECT COUNT(interface_flag)

Line 1086: DELETE JAI_AR_TRX_INS_HDRS_T

1082: --Ended by Anujsax for Bug#5636544
1083: END IF;
1084:
1085: END LOOP;
1086: DELETE JAI_AR_TRX_INS_HDRS_T
1087: WHERE CUSTOMER_TRX_ID = v_customer_trx_id;
1088: --Start addition by Anujsax for Bug#5636544
1089: /* ssumaith - bug# 6901521
1090: IF lv_excise_invoice_no IS NOT NULL THEN