APPS.PN_SCHEDULES_ITEMS dependencies on PN_INDEX_LEASES_ALL

Line 8261: FROM pn_index_leases_all ilease, pn_index_lease_periods_all period

8257: CURSOR no_periods_exist_cur IS
8258: SELECT 'Y'
8259: FROM DUAL
8260: WHERE NOT EXISTS ( SELECT NULL
8261: FROM pn_index_leases_all ilease, pn_index_lease_periods_all period
8262: WHERE ilease.lease_id = p_lease_id
8263: AND period.index_lease_id = ilease.index_lease_id);
8264:
8265: l_lease_status_old VARCHAR2(30);