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 3647: pn_index_leases_all pil

3643:
3644: SELECT pil.index_lease_number
3645: INTO l_agreement_number
3646: FROM pn_index_lease_periods_all pilp,
3647: pn_index_leases_all pil
3648: WHERE pilp.index_lease_id = pil.index_lease_id
3649: AND pilp.index_period_id = rec1.index_period_id;
3650:
3651: ELSIF rec1.opex_agr_id IS NOT NULL THEN