APPS.PN_RETRO_ADJUSTMENT_PKG dependencies on PN_PAYMENT_SCHEDULES_ALL

Line 175: pn_payment_schedules_all schedule

171: item.payment_schedule_id,
172: schedule.schedule_date,
173: schedule.payment_status_lookup_code
174: FROM pn_payment_items_all item,
175: pn_payment_schedules_all schedule
176: WHERE item.payment_term_id = p_term_id
177: AND item.payment_schedule_id = schedule.payment_schedule_id
178: AND item.payment_item_type_lookup_code = 'CASH'
179: AND item.last_adjustment_type_code IS NULL

Line 840: pn_payment_schedules_all schedule

836: item.actual_amount amount,
837: schedule.payment_schedule_id,
838: schedule.schedule_date
839: FROM pn_payment_items_all item,
840: pn_payment_schedules_all schedule
841: WHERE schedule.payment_schedule_id = item.payment_schedule_id
842: AND schedule.payment_status_lookup_code = 'DRAFT'
843: AND item.payment_item_id IN
844: (SELECT payment_item_id

Line 1068: FROM pn_payment_schedules_all

1064: )
1065: IS
1066: CURSOR fetch_schedule IS
1067: SELECT payment_schedule_id
1068: FROM pn_payment_schedules_all
1069: WHERE schedule_date = p_schedule_date
1070: AND lease_id = p_lease_id
1071: AND payment_status_lookup_code = 'DRAFT';
1072:

Line 1771: FROM pn_payment_schedules_all

1767: IS
1768:
1769: CURSOR schedules_draft_cur IS
1770: SELECT payment_schedule_id
1771: FROM pn_payment_schedules_all
1772: WHERE lease_id = p_lease_id
1773: AND payment_status_lookup_code IN ('DRAFT', 'ON_HOLD');
1774:
1775: CURSOR find_payment_items_cur (p_sch_id pn_payment_schedules.payment_schedule_id%TYPE)IS

Line 1797: DELETE pn_payment_schedules_all

1793: IF(l_found = FALSE) THEN
1794:
1795: pnp_debug_pkg.log('Deleting schedule id ........'||schedules_draft_rec.payment_schedule_id);
1796:
1797: DELETE pn_payment_schedules_all
1798: WHERE payment_schedule_id = schedules_draft_rec.payment_schedule_id;
1799:
1800: END IF;
1801:

Line 1994: DELETE pn_payment_schedules_all

1990:
1991: l_info := ' deleting schedule id : '||l_sched_id_tbl(i);
1992: pnp_debug_pkg.log(l_info);
1993:
1994: DELETE pn_payment_schedules_all
1995: WHERE payment_schedule_id = l_sched_id_tbl(i);
1996:
1997: END IF;
1998: END LOOP;

Line 2092: FROM pn_payment_schedules_all

2088: )
2089: IS
2090: CURSOR get_last_appr_sched IS
2091: SELECT max(schedule_date) schedule_date
2092: FROM pn_payment_schedules_all
2093: WHERE lease_id = p_lease_id
2094: AND payment_status_lookup_code = 'APPROVED';
2095:
2096: CURSOR org_id_cur IS