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 980: DELETE JAI_AR_TRX_INS_HDRS_T

976: --Ended by Anujsax for Bug#5636544
977: END IF;
978:
979: END LOOP;
980: DELETE JAI_AR_TRX_INS_HDRS_T
981: WHERE CUSTOMER_TRX_ID = v_customer_trx_id;
982: --Start addition by Anujsax for Bug#5636544
983: /* commented this code for bug#7685000, csahoo
984: IF lv_excise_invoice_no IS NOT NULL THEN