APPS.JA_JAINARDR_XMLP_PKG dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 17: AR_PAYMENT_SCHEDULES_ALL C,

13: SUM((B.AMOUNT) * NVL(A.EXCHANGE_RATE
14: ,1))
15: FROM
16: RA_CUSTOMER_TRX_ALL A,
17: AR_PAYMENT_SCHEDULES_ALL C,
18: RA_CUST_TRX_LINE_GL_DIST_ALL B
19: WHERE A.BILL_TO_CUSTOMER_ID = CUSTOMER_ID
20: AND TRUNC(C.GL_DATE) < TRUNC(P_START_DATE)
21: AND A.INVOICE_CURRENCY_CODE = CURR_CODE

Line 33: AR_PAYMENT_SCHEDULES_ALL

29: AND C.PAYMENT_SCHEDULE_ID IN (
30: SELECT
31: MIN(PAYMENT_SCHEDULE_ID)
32: FROM
33: AR_PAYMENT_SCHEDULES_ALL
34: WHERE CUSTOMER_TRX_ID = C.CUSTOMER_TRX_ID );
35: CURSOR GET_ADJUSTMENT_AMOUNT IS
36: SELECT
37: SUM((B.AMOUNT)) SUM_ADJ_AMOUNT,

Line 43: AR_PAYMENT_SCHEDULES_ALL D,

39: ,1))
40: FROM
41: AR_ADJUSTMENTS_ALL B,
42: RA_CUSTOMER_TRX_ALL C,
43: AR_PAYMENT_SCHEDULES_ALL D,
44: GL_CODE_COMBINATIONS E
45: WHERE B.CUSTOMER_TRX_ID = C.CUSTOMER_TRX_ID
46: AND C.BILL_TO_CUSTOMER_ID = CUSTOMER_ID
47: AND E.CODE_COMBINATION_ID = B.CODE_COMBINATION_ID

Line 57: AR_PAYMENT_SCHEDULES_ALL

53: AND D.PAYMENT_SCHEDULE_ID IN (
54: SELECT
55: MIN(PAYMENT_SCHEDULE_ID)
56: FROM
57: AR_PAYMENT_SCHEDULES_ALL
58: WHERE CUSTOMER_TRX_ID = D.CUSTOMER_TRX_ID );
59: CURSOR GET_CREDIT_AMOUNT IS
60: SELECT
61: SUM(A.AMOUNT) SUM_AMOUNT,

Line 203: AR_PAYMENT_SCHEDULES_ALL C,

199: ,1))
200: INTO V_CRE_MEMO_AMT,V_CRE_MEMO_FUNC_AMT
201: FROM
202: RA_CUSTOMER_TRX_ALL A,
203: AR_PAYMENT_SCHEDULES_ALL C,
204: RA_CUST_TRX_LINE_GL_DIST_ALL B
205: WHERE A.BILL_TO_CUSTOMER_ID = CUSTOMER_ID
206: AND TRUNC(C.GL_DATE) < TRUNC(P_START_DATE)
207: AND A.INVOICE_CURRENCY_CODE = CURR_CODE

Line 219: AR_PAYMENT_SCHEDULES_ALL

215: AND C.PAYMENT_SCHEDULE_ID IN (
216: SELECT
217: MIN(PAYMENT_SCHEDULE_ID)
218: FROM
219: AR_PAYMENT_SCHEDULES_ALL
220: WHERE CUSTOMER_TRX_ID = C.CUSTOMER_TRX_ID );
221: OPEN GET_DEBIT_AMOUNT;
222: FETCH GET_DEBIT_AMOUNT
223: INTO V_TR_DR_AMT,V_FUNC_DR_AMT;

Line 303: AR_PAYMENT_SCHEDULES_ALL C,

299: SUM((B.AMOUNT) * NVL(A.EXCHANGE_RATE
300: ,1))
301: FROM
302: RA_CUSTOMER_TRX_ALL A,
303: AR_PAYMENT_SCHEDULES_ALL C,
304: RA_CUST_TRX_LINE_GL_DIST_ALL B
305: WHERE A.BILL_TO_CUSTOMER_ID = CUSTOMER_ID2
306: AND TRUNC(C.GL_DATE) <= TRUNC(P_END_DATE)
307: AND A.INVOICE_CURRENCY_CODE = CURR_CODE1

Line 319: AR_PAYMENT_SCHEDULES_ALL

315: AND C.PAYMENT_SCHEDULE_ID IN (
316: SELECT
317: MIN(PAYMENT_SCHEDULE_ID)
318: FROM
319: AR_PAYMENT_SCHEDULES_ALL
320: WHERE CUSTOMER_TRX_ID = C.CUSTOMER_TRX_ID );
321: CURSOR GET_ADJUSTMENT_AMOUNT IS
322: SELECT
323: SUM((B.AMOUNT)) SUM_ADJ_AMOUNT,

Line 329: AR_PAYMENT_SCHEDULES_ALL D,

325: ,1))
326: FROM
327: AR_ADJUSTMENTS_ALL B,
328: RA_CUSTOMER_TRX_ALL C,
329: AR_PAYMENT_SCHEDULES_ALL D,
330: GL_CODE_COMBINATIONS E
331: WHERE B.CUSTOMER_TRX_ID = C.CUSTOMER_TRX_ID
332: AND E.CODE_COMBINATION_ID = B.CODE_COMBINATION_ID
333: AND C.BILL_TO_CUSTOMER_ID = CUSTOMER_ID2

Line 343: AR_PAYMENT_SCHEDULES_ALL

339: AND D.PAYMENT_SCHEDULE_ID IN (
340: SELECT
341: MIN(PAYMENT_SCHEDULE_ID)
342: FROM
343: AR_PAYMENT_SCHEDULES_ALL
344: WHERE CUSTOMER_TRX_ID = D.CUSTOMER_TRX_ID );
345: CURSOR GET_CREDIT_AMOUNT IS
346: SELECT
347: SUM(A.AMOUNT) SUM_AMOUNT,

Line 489: AR_PAYMENT_SCHEDULES_ALL C,

485: ,1))
486: INTO V_CRE_MEMO_AMT,V_CRE_MEMO_FUNC_AMT
487: FROM
488: RA_CUSTOMER_TRX_ALL A,
489: AR_PAYMENT_SCHEDULES_ALL C,
490: RA_CUST_TRX_LINE_GL_DIST_ALL B
491: WHERE A.BILL_TO_CUSTOMER_ID = CUSTOMER_ID2
492: AND TRUNC(C.GL_DATE) <= TRUNC(P_END_DATE)
493: AND A.INVOICE_CURRENCY_CODE = CURR_CODE1

Line 505: AR_PAYMENT_SCHEDULES_ALL

501: AND C.PAYMENT_SCHEDULE_ID IN (
502: SELECT
503: MIN(PAYMENT_SCHEDULE_ID)
504: FROM
505: AR_PAYMENT_SCHEDULES_ALL
506: WHERE CUSTOMER_TRX_ID = C.CUSTOMER_TRX_ID );
507: OPEN GET_DEBIT_AMOUNT;
508: FETCH GET_DEBIT_AMOUNT
509: INTO V_TR_DR_AMT,V_FUNC_DR_AMT;