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.PNT_PAYMENT_TERMS_PKG dependencies on PN_LEASES_ALL

Line 187: SELECT org_id FROM pn_leases_all WHERE lease_id = X_LEASE_ID;

183: l_legal_entity_id pn_payment_terms.legal_entity_id%TYPE;
184: l_return_status VARCHAR2(2) := NULL;
185:
186: CURSOR org_cur IS
187: SELECT org_id FROM pn_leases_all WHERE lease_id = X_LEASE_ID;
188: l_org_id NUMBER;
189:
190: l_precision NUMBER;
191: l_ext_precision NUMBER;

Line 1263: FROM pn_leases_all

1259: l_context := 'SELECTing lease status';
1260:
1261: SELECT status
1262: INTO l_status
1263: FROM pn_leases_all
1264: WHERE lease_id = X_LEASE_ID;
1265:
1266: l_context := 'SELECTing estimated amt';
1267:

Line 1568: FROM pn_leases_all

1564:
1565: -- Get the details of Approved Schedules
1566: CURSOR c_chk_app_sch IS
1567: SELECT lease_num
1568: FROM pn_leases_all
1569: WHERE lease_id = x_lease_id
1570: AND EXISTS
1571: (
1572: SELECT pps.lease_id

Line 1710: FROM pn_leases_all

1706: l_freq := pn_schedules_items.get_frequency(p_freq_code);
1707:
1708: SELECT payment_term_proration_rule
1709: INTO l_prorate_rule
1710: FROM pn_leases_all
1711: WHERE lease_id = p_lease_id;
1712:
1713: l_context:= 'entering UPDATE loop';
1714: