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.PN_INDEX_LEASE_COMMON_PKG dependencies on PN_PAYMENT_ITEMS_ALL

Line 153: FROM pn_payment_items_all ppi, pn_payment_terms_all ppt

149: SELECT '1'
150: INTO v
151: FROM DUAL
152: WHERE EXISTS ( SELECT 1
153: FROM pn_payment_items_all ppi, pn_payment_terms_all ppt
154: WHERE ppt.payment_term_id = ppi.payment_term_id
155: AND ppi.payment_item_type_lookup_code = 'CASH'
156: AND ( ppi.transferred_to_ap_flag = 'Y'
157: OR ppi.transferred_to_ar_flag = 'Y')

Line 1295: pn_payment_items_all ppi,

1291: SELECT max(SCHEDULE_DATE)
1292: INTO l_max_sch_date
1293: FROM pn_index_lease_periods_all pilp,
1294: pn_payment_terms_all ppt,
1295: pn_payment_items_all ppi,
1296: pn_payment_schedules_all pps
1297: WHERE pilp.index_period_id=ppt.index_period_id
1298: AND ppt.payment_term_id=ppi.payment_term_id
1299: AND pps.payment_schedule_id=ppi.payment_schedule_id

Line 1422: FROM PN_PAYMENT_ITEMS_ALL ppi

1418: AND ppt.lease_id = pl.lease_id
1419: AND ppt.index_period_id = pilp.index_period_id
1420: AND pilp.index_lease_id = p_index_lease_id
1421: AND EXISTS (SELECT NULL
1422: FROM PN_PAYMENT_ITEMS_ALL ppi
1423: WHERE DECODE(pl.lease_class_code,
1424: 'DIRECT', NVL(ppi.transferred_to_ap_flag,'N'),
1425: 'THIRD_PARTY', NVL(ppi.transferred_to_ar_flag,'N'),
1426: 'SUB_LEASE', NVL(ppi.transferred_to_ar_flag,'N')) = 'N'