eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PNRX_RENT_LES dependencies on PN_PAYMENT_ITEMS_ALL

Line 168: FROM pn_payment_items_all ppi, pn_payment_terms_all ppt, pn_payment_schedules_all pps

164: WHERE lease_id = V_LEASE_ID;
165:
166: CURSOR pitem(V_LEASE_ID IN NUMBER) IS
167: SELECT SUM(NVL(ppi.estimated_amount,ppi.actual_amount)) amount
168: FROM pn_payment_items_all ppi, pn_payment_terms_all ppt, pn_payment_schedules_all pps
169: WHERE ppi.payment_term_id = ppt.payment_term_id
170: AND ppi.payment_schedule_id = pps.payment_schedule_id
171: AND ppt.lease_id = V_LEASE_ID
172: AND pps.lease_id = V_LEASE_ID

Line 178: FROM pn_payment_items_all ppi, pn_payment_terms_all ppt, pn_payment_schedules_all pps

174: AND ppt.payment_term_type_code = 'BASER';
175:
176: CURSOR pitem1(V_LEASE_ID IN NUMBER) IS
177: SELECT SUM(NVL(ppi.estimated_amount,ppi.actual_amount)) amount
178: FROM pn_payment_items_all ppi, pn_payment_terms_all ppt, pn_payment_schedules_all pps
179: WHERE ppi.payment_term_id = ppt.payment_term_id
180: AND ppi.payment_schedule_id = pps.payment_schedule_id
181: AND ppt.lease_id = V_LEASE_ID
182: AND pps.lease_id = V_LEASE_ID

Line 188: FROM pn_payment_items_all ppi, pn_payment_terms_all ppt, pn_payment_schedules_all pps

184: AND ppt.payment_term_type_code = 'DEP';
185:
186: CURSOR pitem2(V_LEASE_ID IN NUMBER) IS
187: SELECT SUM(NVL(ppi.estimated_amount,ppi.actual_amount)) amount
188: FROM pn_payment_items_all ppi, pn_payment_terms_all ppt, pn_payment_schedules_all pps
189: WHERE ppi.payment_term_id = ppt.payment_term_id
190: AND ppi.payment_schedule_id = pps.payment_schedule_id
191: AND ppt.lease_id = V_LEASE_ID
192: AND pps.lease_id = V_LEASE_ID

Line 198: FROM pn_payment_items_all ppi, pn_payment_terms_all ppt

194: AND ppt.payment_term_type_code = 'OEXP';
195:
196: CURSOR pitem3(V_LEASE_ID IN NUMBER) IS
197: SELECT SUM(NVL(ppi.estimated_amount,ppi.actual_amount)) amount
198: FROM pn_payment_items_all ppi, pn_payment_terms_all ppt
199: WHERE ppi.payment_term_id = ppt.payment_term_id
200: AND ppt.lease_id = V_LEASE_ID
201: AND ppi.payment_item_type_lookup_code = 'CASH';
202:

Line 205: FROM pn_payment_items_all ppi, pn_payment_terms_all ppt

201: AND ppi.payment_item_type_lookup_code = 'CASH';
202:
203: CURSOR pitem4(V_LEASE_ID IN NUMBER) IS
204: SELECT SUM(NVL(ppi.estimated_amount,ppi.actual_amount)) amount
205: FROM pn_payment_items_all ppi, pn_payment_terms_all ppt
206: WHERE ppi.payment_term_id = ppt.payment_term_id
207: AND ppt.lease_id = V_LEASE_ID
208: AND ppi.payment_item_type_lookup_code = 'CASH'
209: AND (ppi.transferred_to_ap_flag = 'Y' OR