APPS.PN_OPEX_TERMS_PKG dependencies on PN_LEASE_DETAILS

Line 17: l_lease_change_id pn_lease_details.lease_change_id%TYPE;

13: x_return_status IN OUT NOCOPY VARCHAR2
14: ) IS
15: l_lease_class_code pn_leases.lease_class_code%TYPE;
16: l_distribution_id pn_distributions.distribution_id%TYPE;
17: l_lease_change_id pn_lease_details.lease_change_id%TYPE;
18: l_rowid ROWID;
19: l_distribution_count NUMBER := 0;
20: l_inv_start_date DATE;
21: l_payment_start_date DATE;

Line 110: pn_lease_details_all pld

106: INTO l_lease_class_code,
107: l_lease_change_id,
108: l_org_id
109: FROM pn_leases_all pl,
110: pn_lease_details_all pld
111: WHERE pl.lease_id = pld.lease_id
112: AND pld.lease_id = p_lease_id;
113:
114: EXCEPTION

Line 618: l_lease_change_id pn_lease_details.lease_change_id%TYPE;

614: ) IS
615:
616: l_lease_class_code pn_leases.lease_class_code%TYPE;
617: l_distribution_id pn_distributions.distribution_id%TYPE;
618: l_lease_change_id pn_lease_details.lease_change_id%TYPE;
619: l_rowid ROWID;
620: l_distribution_count NUMBER := 0;
621: l_inv_start_date DATE;
622: l_payment_start_date DATE;

Line 720: pn_lease_details_all pld

716: INTO l_lease_class_code,
717: l_lease_change_id,
718: l_org_id
719: FROM pn_leases_all pl,
720: pn_lease_details_all pld
721: WHERE pl.lease_id = pld.lease_id
722: AND pld.lease_id = agreement_rec.lease_id;
723: EXCEPTION
724: WHEN TOO_MANY_ROWS THEN