DBA Data[Home] [Help]

APPS.OZF_FUND_RECONCILE_PVT dependencies on AMS_DELIVERABLES_VL

Line 230: FROM ams_deliverables_vl ozf

226: p_code IN VARCHAR2,
227: p_end_date IN DATE) IS
228: SELECT ozf.deliverable_id object_id
229: ,ozf.transaction_currency_code object_curr
230: FROM ams_deliverables_vl ozf
231: WHERE
232: NVL(ozf.actual_complete_date, p_grace_date) <= p_grace_date
233: AND ozf.status_code IN (p_status)
234: AND ozf.deliverable_name = NVL(p_code, ozf.deliverable_name)

Line 2219: FROM ams_deliverables_vl

2215: WHERE event_offer_id = p_object_id;
2216:
2217: CURSOR c_deliverable(p_object_id IN NUMBER) IS
2218: SELECT status_code
2219: FROM ams_deliverables_vl
2220: WHERE deliverable_id = p_object_id;
2221:
2222: CURSOR c_offer(p_object_id IN NUMBER) IS
2223: SELECT status_code