DBA Data[Home] [Help]

APPS.PN_REC_CALC_PKG dependencies on PN_LEASE_DETAILS

Line 4102: l_lease_change_id pn_lease_details.lease_change_id%TYPE;

4098:
4099: l_lease_class_code pn_leases.lease_class_code%TYPE;
4100: l_distribution_id pn_distributions.distribution_id%TYPE;
4101: l_payment_term_id pn_payment_terms.payment_term_id%TYPE;
4102: l_lease_change_id pn_lease_details.lease_change_id%TYPE;
4103: l_rowid ROWID;
4104: l_distribution_count NUMBER := 0;
4105: l_payment_start_date pn_payment_terms.start_date%TYPE;
4106: l_payment_end_date pn_payment_terms.end_date%TYPE;

Line 4199: ,pn_lease_details_all pld

4195: ,pld.lease_change_id
4196: INTO l_lease_class_code
4197: ,l_lease_change_id
4198: FROM pn_leases_all pl
4199: ,pn_lease_details_all pld
4200: WHERE pl.lease_id = pld.lease_id
4201: AND pld.lease_id = p_lease_id;
4202:
4203: EXCEPTION