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 2144: FROM pn_leases_all pl,

2140: DECODE(ppt.normalize, 'Y', 'NORMALIZE') "NORMALIZE",
2141: prop.property_id,
2142: loc.location_code,
2143: popex.created_by
2144: FROM pn_leases_all pl,
2145: pn_opex_agreements_all popex,
2146: pn_payment_terms_all ppt,
2147: pn_properties_all prop,
2148: pn_locations_all loc,