APPS.JAI_AR_SUP_TRX_PKG dependencies on JAI_AR_SUP_CHANGES_ALL

Line 91: -- CURSOR FOR SELECTING ENTRIES FROM THE MASTER TABLE JAI_AR_SUP_CHANGES_ALL WHOSE PROCESS DATE IS NOT NULL --

87: Cursor ch_tax(id number,tax_name number) is select 1 from JAI_AR_TRX_SUP_INV_T where customer_trx_id = id
88: and mapping_type = 'T'
89: and existing_type_id = tax_name;
90:
91: -- CURSOR FOR SELECTING ENTRIES FROM THE MASTER TABLE JAI_AR_SUP_CHANGES_ALL WHOSE PROCESS DATE IS NOT NULL --
92: CURSOR MAP_IDENT IS
93: SELECT SET_OF_BOOKS_ID,
94: ORG_ID,
95: CUSTOMER_ID,

Line 105: FROM JAI_AR_SUP_CHANGES_ALL

101: EFFECTIVE_FROM_DATE,
102: EFFECTIVE_TO_DATE,
103: CONVERSION_RATE,
104: BATCH_ID
105: FROM JAI_AR_SUP_CHANGES_ALL
106: WHERE PROCESS_DATE IS NULL
107: AND BATCH_ID = NVL(P_BATCH_ID,BATCH_ID)
108: ORDER BY SITE_USE_ID,
109: CUSTOMER_ID,

Line 174: FROM JAI_AR_SUP_CHANGES_ALL; */

170: SELECT SET_OF_BOOKS_ID,
171: ORG_ID,
172: CUSTOMER_ID,
173: SITE_USE_ID
174: FROM JAI_AR_SUP_CHANGES_ALL; */
175:
176: BEGIN
177:
178: -- added, Harshita for Bug 4762433

Line 439: UPDATE JAI_AR_SUP_CHANGES_ALL

435: END LOOP;
436: END;
437:
438:
439: UPDATE JAI_AR_SUP_CHANGES_ALL
440: SET PROCESS_DATE = SYSDATE
441: WHERE BATCH_ID = P_BATCH_ID
442: AND PROCESS_DATE IS NULL;
443:

Line 537: JAI_AR_SUP_CHANGES_ALL B

533:
534: CURSOR FETCH_CMB_TAB_INV IS
535: SELECT A.*, B.BATCH_ID
536: FROM JAI_AR_TRX_SUP_INV_T A,
537: JAI_AR_SUP_CHANGES_ALL B
538: WHERE A.MAPPING_ID = B.MAPPING_ID
539: ORDER BY CUSTOMER_TRX_ID;
540:
541: CURSOR CHECK_FOR_INV(INV NUMBER) IS

Line 2022: FROM JAI_AR_SUP_CHANGES_ALL

2018: AND C.salesrep_id = A.salesrep_id;
2019:
2020: CURSOR GET_CONVERSION_RATE(id number) IS
2021: SELECT conversion_rate
2022: FROM JAI_AR_SUP_CHANGES_ALL
2023: where mapping_id = id;
2024:
2025: CURSOR GET_TERM(id number) is
2026: SELECT name