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 1265: FROM pn_leases_all

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

Line 1572: FROM pn_leases_all

1568:
1569: -- Get the details of Approved Schedules
1570: CURSOR c_chk_app_sch IS
1571: SELECT lease_num
1572: FROM pn_leases_all
1573: WHERE lease_id = x_lease_id
1574: AND EXISTS
1575: (
1576: SELECT pps.lease_id

Line 1714: FROM pn_leases_all

1710: l_freq := pn_schedules_items.get_frequency(p_freq_code);
1711:
1712: SELECT payment_term_proration_rule
1713: INTO l_prorate_rule
1714: FROM pn_leases_all
1715: WHERE lease_id = p_lease_id;
1716:
1717: l_context:= 'entering UPDATE loop';
1718: