APPS.XTR_CALCULATION_P dependencies on XTR_PAYMENT_SCHEDULE_V

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,