eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PN_NORM_RENORM_PKG dependencies on PN_PAYMENT_SCHEDULES_ALL

Line 77: pn_payment_schedules_all schedule

73: /* get total approved norm amount */
74: CURSOR GET_NORM_TOTAL IS
75: SELECT NVL(SUM(actual_amount), 0) total_norm_amount
76: FROM pn_payment_items_all item,
77: pn_payment_schedules_all schedule
78: WHERE schedule.lease_id = p_lease_id
79: AND item.payment_schedule_id = schedule.payment_schedule_id
80: AND item.payment_term_id = p_term_id
81: AND item.payment_item_type_lookup_code = 'NORMALIZED'

Line 445: pn_payment_schedules_all schedule

441:
442: CURSOR GET_NORM_TOTAL IS
443: SELECT NVL(SUM(actual_amount), 0) total_norm_amount
444: FROM pn_payment_items_all item,
445: pn_payment_schedules_all schedule
446: WHERE schedule.lease_id = p_lease_id
447: AND item.payment_schedule_id = schedule.payment_schedule_id
448: AND item.payment_term_id = p_term_id
449: AND item.payment_item_type_lookup_code = 'NORMALIZED'

Line 454: FROM pn_payment_schedules_all schedule,

450: AND schedule.payment_status_lookup_code = 'APPROVED';
451:
452: CURSOR GET_LAST_APPRV_SCH IS
453: SELECT MAX(schedule.schedule_date) last_apprv_sch
454: FROM pn_payment_schedules_all schedule,
455: pn_payment_items_all item
456: WHERE schedule.lease_id = p_lease_id
457: AND item.payment_schedule_id = schedule.payment_schedule_id
458: AND schedule.payment_status_lookup_code = 'APPROVED'

Line 465: FROM pn_payment_schedules_all schedule,

461: /* Get schedule ID of a draft schedule containing original payment item
462: post the last approved schedule date */
463: CURSOR GET_ORIG_SCH_AFTER(p_last_apprv_sch DATE) IS
464: SELECT MIN(schedule.schedule_date) first_draft_sch
465: FROM pn_payment_schedules_all schedule,
466: pn_payment_items_all item
467: WHERE schedule.lease_id = p_lease_id
468: AND item.payment_schedule_id = schedule.payment_schedule_id
469: AND schedule.payment_status_lookup_code = 'DRAFT'

Line 477: FROM pn_payment_schedules_all schedule,

473:
474: /* Get schedule ID of a draft schedule containing original payment item */
475: CURSOR GET_FIRST_DRAFT_ORIG_SCH IS
476: SELECT MIN(schedule.schedule_date) first_draft_sch
477: FROM pn_payment_schedules_all schedule,
478: pn_payment_items_all item
479: WHERE schedule.lease_id = p_lease_id
480: AND item.payment_schedule_id = schedule.payment_schedule_id
481: AND schedule.payment_status_lookup_code = 'DRAFT'

Line 489: FROM pn_payment_schedules_all schedule,

485: /* Get schedule ID of a draft schedule - original or adjustment */
486: CURSOR GET_FIRST_DRAFT_SCH IS
487: SELECT MIN(schedule.schedule_date) first_draft_sch,
488: schedule.payment_schedule_id pay_schd_id
489: FROM pn_payment_schedules_all schedule,
490: pn_payment_items_all item
491: WHERE item.payment_schedule_id = schedule.payment_schedule_id
492: AND schedule.payment_status_lookup_code = 'DRAFT'
493: AND item.payment_term_id = p_term_id

Line 906: FROM pn_payment_schedules_all pps,

902: -- Bug#6829173
903: CURSOR GET_TERM_SCHEDULES(c_norm_str_dt pn_payment_terms_all.norm_start_date%TYPE) IS
904: SELECT pps.schedule_date schedule_date,
905: pps.payment_schedule_id payment_schedule_id
906: FROM pn_payment_schedules_all pps,
907: pn_payment_items_all ppi
908: WHERE pps.lease_id = p_lease_id
909: AND pps.schedule_date BETWEEN PN_SCHEDULES_ITEMS.FIRST_DAY(c_norm_str_dt)
910: AND LAST_DAY(g_new_lea_term_dt) --AND LAST_DAY(p_norm_end_dt) /*Bug4956314*/