APPS.PN_REC_CALC_PKG dependencies on PN_PROPERTIES_ALL

Line 179: ,pn_properties_all prop

175: FROM pn_leases pl
176: ,pn_rec_agreements_all pra
177: ,pn_rec_calc_periods_all prc
178: ,pn_locations_all ploc
179: ,pn_properties_all prop
180: WHERE pl.lease_id = pra.lease_id
181: AND pra.customer_id = nvl(p_customer_id,pra.customer_id)
182: AND pra.cust_site_id = nvl(p_cust_site_id,pra.cust_site_id)
183: AND pra.rec_agreement_id = prc.rec_agreement_id

Line 212: ,pn_properties_all prop

208: FROM pn_leases pl
209: ,pn_rec_agreements_all pra
210: ,pn_rec_calc_periods_all prc
211: ,pn_locations_all ploc
212: ,pn_properties_all prop
213: WHERE pl.lease_id = pra.lease_id
214: AND pra.customer_id = nvl(p_customer_id,pra.customer_id)
215: AND pra.cust_site_id = nvl(p_cust_site_id,pra.cust_site_id)
216: AND pra.rec_agreement_id = prc.rec_agreement_id

Line 575: ,pn_properties_all prop

571: ,pra.cust_site_id
572: FROM pn_leases pl
573: ,pn_rec_agreements_all pra
574: ,pn_locations_all ploc
575: ,pn_properties_all prop
576: WHERE pl.lease_id = pra.lease_id
577: AND ploc.location_id = pra.location_id
578: AND ploc.property_id = prop.property_id
579: AND prop.property_code = p_property_name

Line 599: ,pn_properties_all prop

595: ,pra.cust_site_id
596: FROM pn_leases pl
597: ,pn_rec_agreements_all pra
598: ,pn_locations_all ploc
599: ,pn_properties_all prop
600: WHERE pl.lease_id = pra.lease_id
601: AND ploc.location_id = pra.location_id
602: AND ploc.property_id = prop.property_id
603: AND prop.property_code = p_property_name