DBA Data[Home] [Help]

APPS.OZF_FUND_RECONCILE_PVT dependencies on AMS_DELIVERABLES_VL

Line 227: FROM ams_deliverables_vl ozf

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

Line 2171: FROM ams_deliverables_vl

2167: WHERE event_offer_id = p_object_id;
2168:
2169: CURSOR c_deliverable(p_object_id IN NUMBER) IS
2170: SELECT status_code
2171: FROM ams_deliverables_vl
2172: WHERE deliverable_id = p_object_id;
2173:
2174: CURSOR c_offer(p_object_id IN NUMBER) IS
2175: SELECT status_code