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 534: FROM pn_leases pl

530: ,pra.lease_id
531: ,pra.location_id
532: ,pra.customer_id
533: ,pra.cust_site_id
534: FROM pn_leases pl
535: ,pn_rec_agreements_all pra
536: ,pn_locations_all ploc
537: WHERE pl.lease_id = pra.lease_id
538: AND ploc.location_id = pra.location_id

Line 555: FROM pn_leases pl

551: ,pra.lease_id
552: ,pra.location_id
553: ,pra.customer_id
554: ,pra.cust_site_id
555: FROM pn_leases pl
556: ,pn_rec_agreements_all pra
557: WHERE pl.lease_id = pra.lease_id
558: AND pl.lease_num >= nvl(p_lease_num_from, pl.lease_num)
559: AND pl.lease_num <= nvl(p_lease_num_to, pl.lease_num)

Line 572: FROM pn_leases pl

568: ,pra.lease_id
569: ,pra.location_id
570: ,pra.customer_id
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

Line 596: FROM pn_leases pl

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

Line 4014: l_lease_class_code pn_leases.lease_class_code%TYPE;

4010: ,p_error IN OUT NOCOPY VARCHAR2
4011: ,p_error_code IN OUT NOCOPY NUMBER
4012: ) IS
4013:
4014: l_lease_class_code pn_leases.lease_class_code%TYPE;
4015: l_distribution_id pn_distributions.distribution_id%TYPE;
4016: l_payment_term_id pn_payment_terms.payment_term_id%TYPE;
4017: l_lease_change_id pn_lease_details.lease_change_id%TYPE;
4018: l_rowid ROWID;

Line 4088: FROM pn_leases_all

4084:
4085:
4086: CURSOR org_cur IS
4087: SELECT org_id
4088: FROM pn_leases_all
4089: WHERE lease_id = p_lease_id;
4090:
4091: l_org_id NUMBER;
4092:

Line 4113: FROM pn_leases_all pl

4109: SELECT pl.lease_class_code
4110: ,pld.lease_change_id
4111: INTO l_lease_class_code
4112: ,l_lease_change_id
4113: FROM pn_leases_all pl
4114: ,pn_lease_details_all pld
4115: WHERE pl.lease_id = pld.lease_id
4116: AND pld.lease_id = p_lease_id;
4117: