APPS.JAI_AR_SUP_TRX_PKG dependencies on JAI_AR_SUP_CHANGES_ALL

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

99: Cursor ch_tax(id number,tax_name number) is select 1 from JAI_AR_TRX_SUP_INV_T where customer_trx_id = id
100: and mapping_type = 'T'
101: and existing_type_id = tax_name;
102:
103: -- CURSOR FOR SELECTING ENTRIES FROM THE MASTER TABLE JAI_AR_SUP_CHANGES_ALL WHOSE PROCESS DATE IS NOT NULL --
104: CURSOR MAP_IDENT IS
105: SELECT SET_OF_BOOKS_ID,
106: ORG_ID,
107: CUSTOMER_ID,

Line 117: FROM JAI_AR_SUP_CHANGES_ALL

113: EFFECTIVE_FROM_DATE,
114: EFFECTIVE_TO_DATE,
115: CONVERSION_RATE,
116: BATCH_ID
117: FROM JAI_AR_SUP_CHANGES_ALL
118: WHERE PROCESS_DATE IS NULL
119: AND BATCH_ID = NVL(P_BATCH_ID,BATCH_ID)
120: ORDER BY SITE_USE_ID,
121: CUSTOMER_ID,

Line 209: FROM JAI_AR_SUP_CHANGES_ALL; */

205: SELECT SET_OF_BOOKS_ID,
206: ORG_ID,
207: CUSTOMER_ID,
208: SITE_USE_ID
209: FROM JAI_AR_SUP_CHANGES_ALL; */
210:
211:
212: ln_open_api number;--Added by zhiwei for Bug#12615714
213: BEGIN

Line 509: UPDATE JAI_AR_SUP_CHANGES_ALL

505: END;
506:
507:
508:
509: UPDATE JAI_AR_SUP_CHANGES_ALL
510: SET PROCESS_DATE = SYSDATE
511: WHERE BATCH_ID = P_BATCH_ID
512: AND PROCESS_DATE IS NULL;
513:

Line 607: JAI_AR_SUP_CHANGES_ALL B

603:
604: CURSOR FETCH_CMB_TAB_INV IS
605: SELECT A.*, B.BATCH_ID
606: FROM JAI_AR_TRX_SUP_INV_T A,
607: JAI_AR_SUP_CHANGES_ALL B
608: WHERE A.MAPPING_ID = B.MAPPING_ID
609: ORDER BY CUSTOMER_TRX_ID;
610:
611: CURSOR CHECK_FOR_INV(INV NUMBER) IS

Line 2151: FROM JAI_AR_SUP_CHANGES_ALL

2147: AND C.salesrep_id = A.salesrep_id;
2148:
2149: CURSOR GET_CONVERSION_RATE(id number) IS
2150: SELECT conversion_rate
2151: FROM JAI_AR_SUP_CHANGES_ALL
2152: where mapping_id = id;
2153:
2154: CURSOR GET_TERM(id number) is
2155: SELECT name