APPS.PN_RETRO_ADJUSTMENT_PKG dependencies on PN_LEASES_ALL

Line 1083: FROM pn_leases_all

1079: AND payment_term_id = p_term_id);
1080:
1081: CURSOR org_id_cur IS
1082: SELECT org_id
1083: FROM pn_leases_all
1084: WHERE lease_id = p_lease_id;
1085:
1086: l_rowid VARCHAR2(100);
1087: l_found BOOLEAN := FALSE;

Line 1766: PROCEDURE cleanup_schedules(p_lease_id pn_leases_all.lease_id%TYPE)

1762: -- 08-OCT-04 piagrawa o Bug 4354810 - Overloaded for mini -retro.
1763: -- 04-APR-06 piagrawa o Bug#5107134 - modified schedules_draft_cur to include
1764: -- status 'ON_HOLD'
1765: ------------------------------------------------------------------------------+
1766: PROCEDURE cleanup_schedules(p_lease_id pn_leases_all.lease_id%TYPE)
1767: IS
1768:
1769: CURSOR schedules_draft_cur IS
1770: SELECT payment_schedule_id

Line 2098: FROM pn_leases_all

2094: AND payment_status_lookup_code = 'APPROVED';
2095:
2096: CURSOR org_id_cur IS
2097: SELECT org_id
2098: FROM pn_leases_all
2099: WHERE lease_id = p_lease_id;
2100:
2101: l_virtual_sched payment_item_tbl_type;
2102: l_current_sched payment_item_tbl_type;