APPS.PN_OPEX_TERMS_PKG dependencies on PN_LEASES

Line 15: l_lease_class_code pn_leases.lease_class_code%TYPE;

11: x_payment_term_id OUT NOCOPY NUMBER,
12: x_catch_up_term_id OUT NOCOPY NUMBER,
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;

Line 109: FROM pn_leases_all pl,

105: pl.org_id
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:

Line 616: l_lease_class_code pn_leases.lease_class_code%TYPE;

612: x_payment_term_id OUT NOCOPY NUMBER,
613: x_return_status IN OUT NOCOPY VARCHAR2
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;

Line 719: FROM pn_leases_all pl,

715: pl.org_id
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

Line 2175: FROM pn_leases_all pl,

2171: DECODE(ppt.normalize, 'Y', 'NORMALIZE') "NORMALIZE",
2172: prop.property_id,
2173: loc.location_code,
2174: popex.created_by
2175: FROM pn_leases_all pl,
2176: pn_opex_agreements_all popex,
2177: pn_payment_terms_all ppt,
2178: pn_properties_all prop,
2179: pn_locations_all loc,