APPS.PN_SCHEDULES_ITEMS dependencies on PN_INDEX_LEASES_ALL

Line 7070: FROM pn_index_leases_all ilease, pn_index_lease_periods_all period

7066: CURSOR no_periods_exist_cur IS
7067: SELECT 'Y'
7068: FROM DUAL
7069: WHERE NOT EXISTS ( SELECT NULL
7070: FROM pn_index_leases_all ilease, pn_index_lease_periods_all period
7071: WHERE ilease.lease_id = p_lease_id
7072: AND period.index_lease_id = ilease.index_lease_id);
7073:
7074: l_lease_status_old VARCHAR2(30);