DBA Data[Home] [Help]

APPS.PNT_PAYMENT_TERMS_PKG dependencies on PN_INDEX_LEASES_ALL

Line 200: FROM pn_index_leases_all

196:
197: CURSOR index_rents_csr IS
198: SELECT index_lease_id
199: ,lease_id
200: FROM pn_index_leases_all
201: WHERE lease_id = x_lease_id
202: AND GROSS_FLAG = 'Y';
203:
204:

Line 3643: pn_index_leases_all pil

3639:
3640: SELECT pil.index_lease_number
3641: INTO l_agreement_number
3642: FROM pn_index_lease_periods_all pilp,
3643: pn_index_leases_all pil
3644: WHERE pilp.index_lease_id = pil.index_lease_id
3645: AND pilp.index_period_id = rec1.index_period_id;
3646:
3647: ELSIF rec1.opex_agr_id IS NOT NULL THEN