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 80: pn_payment_schedules_all schedule

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

Line 173: pn_payment_schedules_all pps

169: --Fix for bug#14143342
170: SELECT NVL(SUM(ppi.actual_amount),0) /* 6893609 */
171: INTO l_app_amt
172: FROM pn_payment_items_all ppi,
173: pn_payment_schedules_all pps
174: WHERE ppi.payment_term_id = p_term_id
175: AND ppi.payment_item_type_lookup_code = 'NORMALIZED'
176: AND pps.payment_schedule_id = ppi.payment_schedule_id
177: AND pps.payment_status_lookup_code <> 'DRAFT'

Line 189: pn_payment_schedules_all pps

185: --Fix for bug#14143342
186: SELECT NVL(SUM(ppi.actual_amount),0)
187: INTO l_dft_amt
188: FROM pn_payment_items_all ppi,
189: pn_payment_schedules_all pps
190: WHERE ppi.payment_term_id = p_term_id
191: AND ppi.payment_item_type_lookup_code = 'NORMALIZED'
192: AND pps.payment_schedule_id = ppi.payment_schedule_id
193: AND pps.payment_status_lookup_code = 'DRAFT'

Line 201: pn_payment_schedules_all pps

197:
198: Select NVL(SUM(ppi.actual_amount),0)
199: into l_term_amt
200: FROM pn_payment_items_all ppi,
201: pn_payment_schedules_all pps
202: WHERE ppi.payment_term_id = p_term_id
203: AND ppi.payment_item_type_lookup_code = 'NORMALIZED'
204: AND pps.payment_schedule_id = ppi.payment_schedule_id
205: AND pps.payment_status_lookup_code <> 'DRAFT'

Line 397: pn_payment_schedules_all pps

393: begin -- ver6
394: SELECT SUM(actual_amount) /* Bug 6893609*/
395: into l_act_amt
396: FROM pn_payment_items_all ppi,
397: pn_payment_schedules_all pps
398: WHERE ppi.payment_item_type_lookup_code = 'NORMALIZED'
399: AND pps.payment_schedule_id = ppi.payment_schedule_id
400: AND ppi.payment_term_id = p_term_id
401: AND pps.payment_status_lookup_code <> 'DRAFT'

Line 569: pn_payment_schedules_all schedule

565:
566: CURSOR GET_NORM_TOTAL IS
567: SELECT NVL(SUM(actual_amount), 0) total_norm_amount
568: FROM pn_payment_items_all item,
569: pn_payment_schedules_all schedule
570: WHERE schedule.lease_id = p_lease_id
571: AND item.payment_schedule_id = schedule.payment_schedule_id
572: AND item.payment_term_id = p_term_id
573: AND item.payment_item_type_lookup_code = 'NORMALIZED'

Line 578: FROM pn_payment_schedules_all schedule,

574: AND schedule.payment_status_lookup_code <> 'DRAFT'; /*= 'APPROVED'; for bug# 7149537*/
575:
576: CURSOR GET_LAST_APPRV_SCH IS
577: SELECT MAX(schedule.schedule_date) last_apprv_sch
578: FROM pn_payment_schedules_all schedule,
579: pn_payment_items_all item
580: WHERE schedule.lease_id = p_lease_id
581: AND item.payment_schedule_id = schedule.payment_schedule_id
582: AND schedule.payment_status_lookup_code = 'APPROVED'

Line 589: FROM pn_payment_schedules_all schedule,

585: /* Get schedule ID of a draft schedule containing original payment item
586: post the last approved schedule date */
587: CURSOR GET_ORIG_SCH_AFTER(p_last_apprv_sch DATE) IS
588: SELECT MIN(schedule.schedule_date) first_draft_sch
589: FROM pn_payment_schedules_all schedule,
590: pn_payment_items_all item
591: WHERE schedule.lease_id = p_lease_id
592: AND item.payment_schedule_id = schedule.payment_schedule_id
593: AND schedule.payment_status_lookup_code = 'DRAFT'

Line 601: FROM pn_payment_schedules_all schedule,

597:
598: /* Get schedule ID of a draft schedule containing original payment item */
599: CURSOR GET_FIRST_DRAFT_ORIG_SCH IS
600: SELECT MIN(schedule.schedule_date) first_draft_sch
601: FROM pn_payment_schedules_all schedule,
602: pn_payment_items_all item
603: WHERE schedule.lease_id = p_lease_id
604: AND item.payment_schedule_id = schedule.payment_schedule_id
605: AND schedule.payment_status_lookup_code = 'DRAFT'

Line 613: FROM pn_payment_schedules_all schedule,

609: /* Get schedule ID of a draft schedule - original or adjustment */
610: CURSOR GET_FIRST_DRAFT_SCH IS
611: SELECT MIN(schedule.schedule_date) first_draft_sch,
612: schedule.payment_schedule_id pay_schd_id
613: FROM pn_payment_schedules_all schedule,
614: pn_payment_items_all item
615: WHERE item.payment_schedule_id = schedule.payment_schedule_id
616: AND schedule.payment_status_lookup_code = 'DRAFT'
617: AND item.payment_term_id = p_term_id

Line 1034: FROM pn_payment_schedules_all pps,

1030: -- Bug#6829173
1031: CURSOR GET_TERM_SCHEDULES(c_norm_str_dt pn_payment_terms_all.norm_start_date%TYPE) IS
1032: SELECT pps.schedule_date schedule_date,
1033: pps.payment_schedule_id payment_schedule_id
1034: FROM pn_payment_schedules_all pps,
1035: pn_payment_items_all ppi
1036: WHERE pps.lease_id = p_lease_id
1037: AND pps.schedule_date BETWEEN
1038: NVL(PN_SCHEDULES_ITEMS.FIRST_DAY(l_amd_comn_date),PN_SCHEDULES_ITEMS.FIRST_DAY(c_norm_str_dt)) /*6838211 */