APPS.XTR_CALCULATION_P dependencies on XTR_PAYMENT_SCHEDULE

Line 329: from XTR_PAYMENT_SCHEDULE

325: JAN_YN,FEB_YN,MAR_YN,APR_YN,MAY_YN,JUN_YN,JUL_YN,AUG_YN,
326: SEP_YN,OCT_YN,NOV_YN,DEC_YN,PAYMENT_SCHEDULE_CODE,
327: PAYMENT_FREQUENCY,MIN_POSTINGS,POSTING_FREQ,
328: NEXT_POSTING_DUE
329: from XTR_PAYMENT_SCHEDULE
330: where PAYMENT_SCHEDULE_CODE = P_PAYMENT_SCHEDULE_CODE
331: and DEAL_TYPE = 'RTMM'
332: and DEAL_SUBTYPE = P_DEAL_SUBTYPE
333: and PRODUCT_TYPE = P_PRODUCT_TYPE

Line 336: L_PAYMENT_SCHEDULE_CODE XTR_PAYMENT_SCHEDULE_V.PAYMENT_SCHEDULE_CODE%TYPE;

332: and DEAL_SUBTYPE = P_DEAL_SUBTYPE
333: and PRODUCT_TYPE = P_PRODUCT_TYPE
334: and nvl(NEXT_POSTING_DUE, l_start_date) <= l_start_date;
335:
336: L_PAYMENT_SCHEDULE_CODE XTR_PAYMENT_SCHEDULE_V.PAYMENT_SCHEDULE_CODE%TYPE;
337: L_PAYMENT_FREQUENCY XTR_PAYMENT_SCHEDULE_V.PAYMENT_FREQUENCY%TYPE;
338: L_MIN_POSTINGS XTR_PAYMENT_SCHEDULE_V.MIN_POSTINGS%TYPE;
339: L_POSTING_FREQ XTR_PAYMENT_SCHEDULE_V.POSTING_FREQ%TYPE;
340: L_NEXT_POSTING_DUE XTR_PAYMENT_SCHEDULE_V.NEXT_POSTING_DUE%TYPE;

Line 337: L_PAYMENT_FREQUENCY XTR_PAYMENT_SCHEDULE_V.PAYMENT_FREQUENCY%TYPE;

333: and PRODUCT_TYPE = P_PRODUCT_TYPE
334: and nvl(NEXT_POSTING_DUE, l_start_date) <= l_start_date;
335:
336: L_PAYMENT_SCHEDULE_CODE XTR_PAYMENT_SCHEDULE_V.PAYMENT_SCHEDULE_CODE%TYPE;
337: L_PAYMENT_FREQUENCY XTR_PAYMENT_SCHEDULE_V.PAYMENT_FREQUENCY%TYPE;
338: L_MIN_POSTINGS XTR_PAYMENT_SCHEDULE_V.MIN_POSTINGS%TYPE;
339: L_POSTING_FREQ XTR_PAYMENT_SCHEDULE_V.POSTING_FREQ%TYPE;
340: L_NEXT_POSTING_DUE XTR_PAYMENT_SCHEDULE_V.NEXT_POSTING_DUE%TYPE;
341:

Line 338: L_MIN_POSTINGS XTR_PAYMENT_SCHEDULE_V.MIN_POSTINGS%TYPE;

334: and nvl(NEXT_POSTING_DUE, l_start_date) <= l_start_date;
335:
336: L_PAYMENT_SCHEDULE_CODE XTR_PAYMENT_SCHEDULE_V.PAYMENT_SCHEDULE_CODE%TYPE;
337: L_PAYMENT_FREQUENCY XTR_PAYMENT_SCHEDULE_V.PAYMENT_FREQUENCY%TYPE;
338: L_MIN_POSTINGS XTR_PAYMENT_SCHEDULE_V.MIN_POSTINGS%TYPE;
339: L_POSTING_FREQ XTR_PAYMENT_SCHEDULE_V.POSTING_FREQ%TYPE;
340: L_NEXT_POSTING_DUE XTR_PAYMENT_SCHEDULE_V.NEXT_POSTING_DUE%TYPE;
341:
342: cursor DEAL is

Line 339: L_POSTING_FREQ XTR_PAYMENT_SCHEDULE_V.POSTING_FREQ%TYPE;

335:
336: L_PAYMENT_SCHEDULE_CODE XTR_PAYMENT_SCHEDULE_V.PAYMENT_SCHEDULE_CODE%TYPE;
337: L_PAYMENT_FREQUENCY XTR_PAYMENT_SCHEDULE_V.PAYMENT_FREQUENCY%TYPE;
338: L_MIN_POSTINGS XTR_PAYMENT_SCHEDULE_V.MIN_POSTINGS%TYPE;
339: L_POSTING_FREQ XTR_PAYMENT_SCHEDULE_V.POSTING_FREQ%TYPE;
340: L_NEXT_POSTING_DUE XTR_PAYMENT_SCHEDULE_V.NEXT_POSTING_DUE%TYPE;
341:
342: cursor DEAL is
343: select a.DEAL_NO,a.DEAL_DATE,a.START_DATE,a.MATURITY_DATE,

Line 340: L_NEXT_POSTING_DUE XTR_PAYMENT_SCHEDULE_V.NEXT_POSTING_DUE%TYPE;

336: L_PAYMENT_SCHEDULE_CODE XTR_PAYMENT_SCHEDULE_V.PAYMENT_SCHEDULE_CODE%TYPE;
337: L_PAYMENT_FREQUENCY XTR_PAYMENT_SCHEDULE_V.PAYMENT_FREQUENCY%TYPE;
338: L_MIN_POSTINGS XTR_PAYMENT_SCHEDULE_V.MIN_POSTINGS%TYPE;
339: L_POSTING_FREQ XTR_PAYMENT_SCHEDULE_V.POSTING_FREQ%TYPE;
340: L_NEXT_POSTING_DUE XTR_PAYMENT_SCHEDULE_V.NEXT_POSTING_DUE%TYPE;
341:
342: cursor DEAL is
343: select a.DEAL_NO,a.DEAL_DATE,a.START_DATE,a.MATURITY_DATE,
344: a.CPARTY_CODE,a.CLIENT_CODE,a.PRODUCT_TYPE,

Line 685: UPDATE xtr_payment_schedule

681: commit;
682:
683: END LOOP; -- Deal loop
684:
685: UPDATE xtr_payment_schedule
686: SET next_posting_due = add_months(l_start_date,nvl(L_POSTING_FREQ,1))
687: WHERE deal_type = 'RTMM'
688: AND deal_subtype = P_DEAL_SUBTYPE
689: AND product_type = P_PRODUCT_TYPE

Line 715: from XTR_PAYMENT_SCHEDULE

711: IS
712:
713: cursor SCH_CODE is
714: select DEAL_SUBTYPE, PRODUCT_TYPE,PAYMENT_SCHEDULE_CODE
715: from XTR_PAYMENT_SCHEDULE
716: where PAYMENT_SCHEDULE_CODE = nvl(P_PAYMENT_SCHEDULE_CODE,PAYMENT_SCHEDULE_CODE)
717: and DEAL_TYPE = 'RTMM'
718: and DEAL_SUBTYPE = nvl(P_DEAL_SUBTYPE,DEAL_SUBTYPE)
719: and PRODUCT_TYPE = nvl(P_PRODUCT_TYPE,PRODUCT_TYPE)