APPS.PN_INDEX_LEASE_COMMON_PKG dependencies on PN_INDEX_LEASES_ALL

Line 372: FROM pn_index_leases_all

368:
369: v CHAR (1) := 0;
370: CURSOR c IS
371: SELECT *
372: FROM pn_index_leases_all
373: WHERE index_lease_id = p_index_lease_id;
374: BEGIN
375: FOR c_rec IN c
376: LOOP

Line 465: FROM pn_index_lease_periods_all periods, pn_index_leases_all index_leases,

461: )
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

Line 785: FROM pn_index_leases_all pil, pn_term_templates_all ptt

781: SELECT 1
782: INTO l_template_used
783: FROM DUAL
784: WHERE EXISTS ( SELECT pil.index_lease_id
785: FROM pn_index_leases_all pil, pn_term_templates_all ptt
786: WHERE ptt.term_template_id = pil.term_template_id
787: AND ptt.term_template_id = p_term_template_id);
788: RETURN l_template_used;
789: EXCEPTION

Line 1235: ,pn_index_leases_all lease

1231: INTO l_calc_exists
1232: FROM DUAL
1233: WHERE EXISTS ( SELECT terms.payment_term_id
1234: FROM pn_payment_terms_all terms
1235: ,pn_index_leases_all lease
1236: ,pn_index_lease_periods_all periods
1237: WHERE terms.index_period_id = periods.index_period_id
1238: AND periods.index_lease_id = lease.index_lease_id
1239: AND lease.index_lease_id = p_index_lease_id);