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_ITEMS_ALL

Line 72: FROM pn_payment_items_all

68:
69: /* get total cash amount */
70: CURSOR GET_CASH_TOTAL IS
71: SELECT NVL(SUM(actual_amount), 0) total_cash_amount
72: FROM pn_payment_items_all
73: WHERE payment_term_id = p_term_id
74: AND payment_item_type_lookup_code = 'CASH';
75:
76: /* get total approved norm amount */

Line 79: FROM pn_payment_items_all item,

75:
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

Line 127: FROM pn_payment_items_all ppi

123: IS
124: SELECT 1 FROM dual
125: WHERE exists
126: (SELECT 1
127: FROM pn_payment_items_all ppi
128: WHERE ppi.payment_schedule_id = b_schedule_id
129: AND ppi.payment_item_type_lookup_code = 'CASH'
130: AND ppi.payment_term_id = b_term_id
131: );

Line 172: FROM pn_payment_items_all ppi,

168:
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

Line 188: FROM pn_payment_items_all ppi,

184: --Draft schedules should not be deleted before ACD
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

Line 200: FROM pn_payment_items_all ppi,

196: pnp_debug_pkg.log('l_dft_amt : ' || l_dft_amt);
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

Line 396: FROM pn_payment_items_all ppi,

392:
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

Line 413: UPDATE pn_payment_items_all ppi

409: l_act_amt := 0;
410: end;
411:
412: /* first try to update */
413: UPDATE pn_payment_items_all ppi
414: SET ppi.actual_amount = g_norm_item_tbl(i).normalized_amount,
415: ppi.export_currency_amount = g_norm_item_tbl(i).normalized_amount,
416: ppi.last_update_date = SYSDATE,
417: ppi.last_updated_by = NVL(fnd_profile.value('USER_ID'),0),

Line 429: INSERT INTO pn_payment_items_all

425: FOR rec IN org_cur LOOP
426: l_org_id := rec.org_id;
427: END LOOP;
428:
429: INSERT INTO pn_payment_items_all
430: (
431: payment_item_id,
432: last_update_date,
433: last_updated_by,

Line 562: FROM pn_payment_items_all

558: IS
559:
560: CURSOR GET_CASH_TOTAL IS
561: SELECT NVL(SUM(actual_amount), 0) total_cash_amount
562: FROM pn_payment_items_all
563: WHERE payment_term_id = p_term_id
564: AND payment_item_type_lookup_code = 'CASH';
565:
566: CURSOR GET_NORM_TOTAL IS

Line 568: FROM pn_payment_items_all item,

564: AND payment_item_type_lookup_code = 'CASH';
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

Line 579: pn_payment_items_all item

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'
583: AND item.payment_term_id = p_term_id;

Line 590: pn_payment_items_all 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'
594: AND item.payment_term_id = p_term_id

Line 602: pn_payment_items_all item

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'
606: AND item.payment_term_id = p_term_id

Line 614: pn_payment_items_all item

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
618: GROUP BY schedule.payment_schedule_id;

Line 653: FROM pn_payment_items_all ppi

649: IS
650: SELECT 1 FROM dual
651: WHERE exists
652: (SELECT 1
653: FROM pn_payment_items_all ppi
654: WHERE ppi.payment_schedule_id = b_schedule_id
655: AND ppi.payment_item_type_lookup_code = 'CASH'
656: AND ppi.payment_term_id = b_term_id
657: );

Line 872: UPDATE pn_payment_items_all ppi

868: /* start to create/update normalized items */
869: FOR i IN 0 .. g_norm_item_tbl.COUNT - 1 LOOP
870:
871: /* first try to update */
872: UPDATE pn_payment_items_all ppi
873: SET ppi.actual_amount = g_norm_item_tbl(i).normalized_amount,
874: ppi.export_currency_amount = g_norm_item_tbl(i).normalized_amount,
875: ppi.last_update_date = SYSDATE,
876: ppi.last_updated_by = NVL(fnd_profile.value('USER_ID'),0),

Line 888: INSERT INTO pn_payment_items_all

884: FOR rec IN org_cur LOOP
885: l_org_id := rec.org_id;
886: END LOOP;
887:
888: INSERT INTO pn_payment_items_all
889: (payment_item_id,
890: last_update_date,
891: last_updated_by,
892: creation_date,

Line 1035: pn_payment_items_all ppi

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 */
1039: AND LAST_DAY(g_new_lea_term_dt) --AND LAST_DAY(p_norm_end_dt) /*Bug4956314*/