APPS.PN_INDEX_LEASE_COMMON_PKG dependencies on PN_LEASES_ALL

Line 203: FROM pn_leases_all pl, pn_payment_terms_all ppt

199: ,ppt.vendor_site_id
200: ,ppt.customer_id
201: ,ppt.customer_site_use_id
202: ,ppt.code_combination_id
203: FROM pn_leases_all pl, pn_payment_terms_all ppt
204: WHERE pl.lease_id = ppt.lease_id
205: AND ppt.payment_term_id = ip_payment_term_id;
206:
207: rec_payment_term curr_payment_term%ROWTYPE;

Line 466: pn_leases_all leases, pn_lease_details_all lease_det

462: AS
463: CURSOR c IS
464: SELECT index_leases.commencement_date, lease_det.lease_termination_date
465: FROM pn_index_lease_periods_all periods, pn_index_leases_all index_leases,
466: pn_leases_all leases, pn_lease_details_all lease_det
467: WHERE periods.index_period_id = p_index_period_id
468: AND index_leases.index_lease_id = periods.index_lease_id
469: AND index_leases.lease_id = leases.lease_id
470: AND leases.lease_id = lease_det.lease_id

Line 1000: FROM pn_leases_all

996: l_lease_class VARCHAR2 (30);
997: BEGIN
998: SELECT lease_class_code
999: INTO l_lease_class
1000: FROM pn_leases_all
1001: WHERE lease_id = p_lease_id;
1002: RETURN l_lease_class;
1003: EXCEPTION
1004: WHEN OTHERS

Line 1416: PN_LEASES_ALL pl

1412: SELECT ppt.payment_term_id,
1413: NVL(ppt.status, 'X')
1414: FROM PN_PAYMENT_TERMS_ALL ppt,
1415: PN_INDEX_LEASE_PERIODS_ALL pilp,
1416: PN_LEASES_ALL pl
1417: WHERE ppt.status = 'APPROVED'
1418: AND ppt.lease_id = pl.lease_id
1419: AND ppt.index_period_id = pilp.index_period_id
1420: AND pilp.index_lease_id = p_index_lease_id