APPS.PN_VARIABLE_TERM_PKG dependencies on PN_LEASE_DETAILS

Line 58: pn_lease_details_all pld,

54: per.period_num,
55: pl.lease_class_code,
56: pl.org_id
57: FROM pn_leases pl,
58: pn_lease_details_all pld,
59: pn_var_rents_all pvr,
60: pn_locations_all ploc,
61: pn_var_periods_all per
62: WHERE pl.lease_id = pvr.lease_id

Line 92: pn_lease_details_all pld,

88: pl.lease_class_code,
89: pl.org_id
90: FROM pn_var_rents_all pvr,
91: pn_leases pl,
92: pn_lease_details_all pld,
93: pn_var_periods_all per
94: WHERE pl.lease_id = pvr.lease_id
95: AND pld.lease_id = pvr.lease_id
96: AND pvr.var_rent_id = per.var_rent_id

Line 684: l_lease_change_id pn_lease_details.lease_change_id%TYPE;

680:
681: l_lease_class_code pn_leases.lease_class_code%TYPE;
682: l_distribution_id pn_distributions.distribution_id%TYPE;
683: l_payment_term_id pn_payment_terms.payment_term_id%TYPE;
684: l_lease_change_id pn_lease_details.lease_change_id%TYPE;
685: l_rowid ROWID;
686: l_distribution_count NUMBER := 0;
687: l_inv_start_date DATE;
688: l_payment_start_date DATE;

Line 749: pn_lease_details_all pld

745: INTO l_lease_class_code,
746: l_lease_change_id,
747: l_org_id
748: FROM pn_leases_all pl,
749: pn_lease_details_all pld
750: WHERE pl.lease_id = pld.lease_id
751: AND pld.lease_id = p_lease_id;
752:
753: EXCEPTION