APPS.PN_NORM_RENORM_PKG dependencies on PN_PAYMENT_ITEMS_ALL

Line 69: FROM pn_payment_items_all

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

Line 76: FROM pn_payment_items_all item,

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

Line 115: FROM pn_payment_items_all ppi

111: IS
112: SELECT 1 FROM dual
113: WHERE exists
114: (SELECT 1
115: FROM pn_payment_items_all ppi
116: WHERE ppi.payment_schedule_id = b_schedule_id
117: AND ppi.payment_item_type_lookup_code = 'CASH'
118: AND ppi.payment_term_id = b_term_id
119: );

Line 289: UPDATE pn_payment_items_all ppi

285: /* start to create/update normalized items */
286: FOR i IN 0 .. g_norm_item_tbl.COUNT - 1 LOOP
287:
288: /* first try to update */
289: UPDATE pn_payment_items_all ppi
290: SET ppi.actual_amount = g_norm_item_tbl(i).normalized_amount,
291: ppi.export_currency_amount = g_norm_item_tbl(i).normalized_amount,
292: ppi.last_update_date = SYSDATE,
293: ppi.last_updated_by = NVL(fnd_profile.value('USER_ID'),0),

Line 305: INSERT INTO pn_payment_items_all

301: FOR rec IN org_cur LOOP
302: l_org_id := rec.org_id;
303: END LOOP;
304:
305: INSERT INTO pn_payment_items_all
306: (
307: payment_item_id,
308: last_update_date,
309: last_updated_by,

Line 438: FROM pn_payment_items_all

434: IS
435:
436: CURSOR GET_CASH_TOTAL IS
437: SELECT NVL(SUM(actual_amount), 0) total_cash_amount
438: FROM pn_payment_items_all
439: WHERE payment_term_id = p_term_id
440: AND payment_item_type_lookup_code = 'CASH';
441:
442: CURSOR GET_NORM_TOTAL IS

Line 444: FROM pn_payment_items_all item,

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

Line 455: pn_payment_items_all item

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

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

Line 478: pn_payment_items_all item

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

Line 490: pn_payment_items_all item

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

Line 529: FROM pn_payment_items_all ppi

525: IS
526: SELECT 1 FROM dual
527: WHERE exists
528: (SELECT 1
529: FROM pn_payment_items_all ppi
530: WHERE ppi.payment_schedule_id = b_schedule_id
531: AND ppi.payment_item_type_lookup_code = 'CASH'
532: AND ppi.payment_term_id = b_term_id
533: );

Line 748: UPDATE pn_payment_items_all ppi

744: /* start to create/update normalized items */
745: FOR i IN 0 .. g_norm_item_tbl.COUNT - 1 LOOP
746:
747: /* first try to update */
748: UPDATE pn_payment_items_all ppi
749: SET ppi.actual_amount = g_norm_item_tbl(i).normalized_amount,
750: ppi.export_currency_amount = g_norm_item_tbl(i).normalized_amount,
751: ppi.last_update_date = SYSDATE,
752: ppi.last_updated_by = NVL(fnd_profile.value('USER_ID'),0),

Line 764: INSERT INTO pn_payment_items_all

760: FOR rec IN org_cur LOOP
761: l_org_id := rec.org_id;
762: END LOOP;
763:
764: INSERT INTO pn_payment_items_all
765: (payment_item_id,
766: last_update_date,
767: last_updated_by,
768: creation_date,

Line 907: pn_payment_items_all ppi

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*/
911: AND pps.payment_status_lookup_code = 'DRAFT' /* bug 6737971 removed