APPS.PN_REC_CALC_PKG dependencies on PN_LOCATIONS_ALL

Line 104: FROM pn_locations_all

100: WHERE lease_id = p_lease_id;
101:
102: CURSOR csr_get_location IS
103: SELECT location_code
104: FROM pn_locations_all
105: WHERE location_id = p_location_id
106: AND NVL(l_as_of_date,sysdate) between active_start_date and
107: active_end_date;
108:

Line 122: ,pn_locations_all ploc

118: ,prc.rec_calc_period_id
119: FROM pn_leases pl
120: ,pn_rec_agreements_all pra
121: ,pn_rec_calc_periods_all prc
122: ,pn_locations_all ploc
123: WHERE pl.lease_id = pra.lease_id
124: AND pra.customer_id = nvl(p_customer_id,pra.customer_id)
125: AND pra.cust_site_id = nvl(p_cust_site_id,pra.cust_site_id)
126: AND pra.rec_agreement_id = prc.rec_agreement_id

Line 178: ,pn_locations_all ploc

174: ,prc.rec_calc_period_id
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)

Line 211: ,pn_locations_all ploc

207: ,prc.rec_calc_period_id
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)

Line 561: ,pn_locations_all ploc

557: ,pra.customer_id
558: ,pra.cust_site_id
559: FROM pn_leases pl
560: ,pn_rec_agreements_all pra
561: ,pn_locations_all ploc
562: WHERE pl.lease_id = pra.lease_id
563: AND ploc.location_id = pra.location_id
564: AND pl.lease_num >= nvl(p_lease_num_from, pl.lease_num)
565: AND pl.lease_num <= nvl(p_lease_num_to, pl.lease_num)

Line 599: ,pn_locations_all ploc

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

Line 623: ,pn_locations_all ploc

619: ,pra.customer_id
620: ,pra.cust_site_id
621: FROM pn_leases pl
622: ,pn_rec_agreements_all pra
623: ,pn_locations_all ploc
624: ,pn_properties_all prop
625: WHERE pl.lease_id = pra.lease_id
626: AND ploc.location_id = pra.location_id
627: AND ploc.property_id = prop.property_id