APPS.PN_VARIABLE_TERM_PKG dependencies on PN_LEASE_DETAILS

Line 55: pn_lease_details_all pld,

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

Line 89: pn_lease_details_all pld,

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

Line 680: l_lease_change_id pn_lease_details.lease_change_id%TYPE;

676:
677: l_lease_class_code pn_leases.lease_class_code%TYPE;
678: l_distribution_id pn_distributions.distribution_id%TYPE;
679: l_payment_term_id pn_payment_terms.payment_term_id%TYPE;
680: l_lease_change_id pn_lease_details.lease_change_id%TYPE;
681: l_rowid ROWID;
682: l_distribution_count NUMBER := 0;
683: l_inv_start_date DATE;
684: l_payment_start_date DATE;

Line 745: pn_lease_details_all pld

741: INTO l_lease_class_code,
742: l_lease_change_id,
743: l_org_id
744: FROM pn_leases_all pl,
745: pn_lease_details_all pld
746: WHERE pl.lease_id = pld.lease_id
747: AND pld.lease_id = p_lease_id;
748:
749: EXCEPTION