APPS.PN_REC_CALC_PKG dependencies on PN_LEASES

Line 99: FROM pn_leases_all

95:
96: CURSOR csr_get_lease IS
97: SELECT name,
98: lease_num
99: FROM pn_leases_all
100: WHERE lease_id = p_lease_id;
101:
102: CURSOR csr_get_location IS
103: SELECT location_code

Line 119: FROM pn_leases pl

115: ,prc.start_date
116: ,prc.end_date
117: ,prc.as_of_date
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

Line 149: FROM pn_leases pl

145: ,prc.start_date
146: ,prc.end_date
147: ,prc.as_of_date
148: ,prc.rec_calc_period_id
149: FROM pn_leases pl
150: ,pn_rec_agreements_all pra
151: ,pn_rec_calc_periods_all prc
152: WHERE pl.lease_id = pra.lease_id
153: AND pra.customer_id = nvl(p_customer_id,pra.customer_id)

Line 175: FROM pn_leases pl

171: ,prc.start_date
172: ,prc.end_date
173: ,prc.as_of_date
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

Line 208: FROM pn_leases pl

204: ,prc.start_date
205: ,prc.end_date
206: ,prc.as_of_date
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

Line 559: FROM pn_leases pl

555: ,pra.lease_id
556: ,pra.location_id
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

Line 580: FROM pn_leases pl

576: ,pra.lease_id
577: ,pra.location_id
578: ,pra.customer_id
579: ,pra.cust_site_id
580: FROM pn_leases pl
581: ,pn_rec_agreements_all pra
582: WHERE pl.lease_id = pra.lease_id
583: AND pl.lease_num >= nvl(p_lease_num_from, pl.lease_num)
584: AND pl.lease_num <= nvl(p_lease_num_to, pl.lease_num)

Line 597: FROM pn_leases pl

593: ,pra.lease_id
594: ,pra.location_id
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

Line 621: FROM pn_leases pl

617: ,pra.lease_id
618: ,pra.location_id
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

Line 4099: l_lease_class_code pn_leases.lease_class_code%TYPE;

4095: ,p_error IN OUT NOCOPY VARCHAR2
4096: ,p_error_code IN OUT NOCOPY NUMBER
4097: ) IS
4098:
4099: l_lease_class_code pn_leases.lease_class_code%TYPE;
4100: l_distribution_id pn_distributions.distribution_id%TYPE;
4101: l_payment_term_id pn_payment_terms.payment_term_id%TYPE;
4102: l_lease_change_id pn_lease_details.lease_change_id%TYPE;
4103: l_rowid ROWID;

Line 4173: FROM pn_leases_all

4169:
4170:
4171: CURSOR org_cur IS
4172: SELECT org_id
4173: FROM pn_leases_all
4174: WHERE lease_id = p_lease_id;
4175:
4176: l_org_id NUMBER;
4177:

Line 4198: FROM pn_leases_all pl

4194: SELECT pl.lease_class_code
4195: ,pld.lease_change_id
4196: INTO l_lease_class_code
4197: ,l_lease_change_id
4198: FROM pn_leases_all pl
4199: ,pn_lease_details_all pld
4200: WHERE pl.lease_id = pld.lease_id
4201: AND pld.lease_id = p_lease_id;
4202: