APPS.PN_RETRO_ADJUSTMENT_PKG dependencies on PN_PAYMENT_SCHEDULES_ALL

Line 196: pn_payment_schedules_all schedule

192: item.payment_schedule_id,
193: schedule.schedule_date,
194: schedule.payment_status_lookup_code
195: FROM pn_payment_items_all item,
196: pn_payment_schedules_all schedule
197: WHERE item.payment_term_id = p_term_id
198: AND item.payment_schedule_id = schedule.payment_schedule_id
199: AND item.payment_item_type_lookup_code = 'CASH'
200: AND item.last_adjustment_type_code IS NULL

Line 861: pn_payment_schedules_all schedule

857: item.actual_amount amount,
858: schedule.payment_schedule_id,
859: schedule.schedule_date
860: FROM pn_payment_items_all item,
861: pn_payment_schedules_all schedule
862: WHERE schedule.payment_schedule_id = item.payment_schedule_id
863: AND schedule.payment_status_lookup_code = 'DRAFT'
864: AND item.payment_item_id IN
865: (SELECT payment_item_id

Line 1089: FROM pn_payment_schedules_all

1085: )
1086: IS
1087: CURSOR fetch_schedule IS
1088: SELECT payment_schedule_id
1089: FROM pn_payment_schedules_all
1090: WHERE schedule_date = p_schedule_date
1091: AND lease_id = p_lease_id
1092: AND payment_status_lookup_code = 'DRAFT';
1093:

Line 1792: FROM pn_payment_schedules_all

1788: IS
1789:
1790: CURSOR schedules_draft_cur IS
1791: SELECT payment_schedule_id
1792: FROM pn_payment_schedules_all
1793: WHERE lease_id = p_lease_id
1794: AND payment_status_lookup_code IN ('DRAFT', 'ON_HOLD');
1795:
1796: CURSOR find_payment_items_cur (p_sch_id pn_payment_schedules.payment_schedule_id%TYPE)IS

Line 1818: DELETE pn_payment_schedules_all

1814: IF(l_found = FALSE) THEN
1815:
1816: pnp_debug_pkg.log('Deleting schedule id ........'||schedules_draft_rec.payment_schedule_id);
1817:
1818: DELETE pn_payment_schedules_all
1819: WHERE payment_schedule_id = schedules_draft_rec.payment_schedule_id;
1820:
1821: END IF;
1822:

Line 2015: DELETE pn_payment_schedules_all

2011:
2012: l_info := ' deleting schedule id : '||l_sched_id_tbl(i);
2013: pnp_debug_pkg.log(l_info);
2014:
2015: DELETE pn_payment_schedules_all
2016: WHERE payment_schedule_id = l_sched_id_tbl(i);
2017:
2018: END IF;
2019: END LOOP;

Line 2113: FROM pn_payment_schedules_all

2109: )
2110: IS
2111: CURSOR get_last_appr_sched IS
2112: SELECT max(schedule_date) schedule_date
2113: FROM pn_payment_schedules_all
2114: WHERE lease_id = p_lease_id
2115: AND payment_status_lookup_code = 'APPROVED';
2116:
2117: CURSOR org_id_cur IS