APPS.AMS_CPAGEUTILITY_PVT dependencies on AMS_DELIVERABLES_VL

Line 81: FROM ams_deliverables_vl

77: ,actual_avail_from_date
78: ,actual_avail_to_date
79: ,deliverable_name
80: ,description
81: FROM ams_deliverables_vl
82: WHERE deliverable_id = p_delv_id ;
83: --
84: l_owner_res_id NUMBER ;
85: l_start_date DATE ;

Line 455: FROM ams_deliverables_vl

451: -- Declare the local variables and cursors here.
452: --
453: CURSOR c_delv_details IS
454: SELECT status_code
455: FROM ams_deliverables_vl
456: WHERE deliverable_id = p_delv_id ;
457: --
458: --
459: l_delv_status_code VARCHAR2(30) ;

Line 920: FROM ams_deliverables_vl

916: --
917: CURSOR c_delv_details IS
918: SELECT actual_avail_from_date
919: ,actual_avail_to_date
920: FROM ams_deliverables_vl
921: WHERE deliverable_id = p_delv_id ;
922: --
923: l_start_date DATE ;
924: l_end_date DATE ;

Line 1468: FROM ams_deliverables_vl

1464: --
1465: CURSOR c_delv_details IS
1466: SELECT actual_avail_from_date
1467: ,actual_avail_to_date
1468: FROM ams_deliverables_vl
1469: WHERE deliverable_id = p_delv_id ;
1470: --
1471: l_start_date DATE ;
1472: l_end_date DATE ;

Line 2337: FROM ams_deliverables_vl

2333: --
2334: CURSOR c_delv_details IS
2335: SELECT actual_avail_from_date
2336: ,actual_avail_to_date
2337: FROM ams_deliverables_vl
2338: WHERE deliverable_id = p_delv_id ;
2339: --
2340: l_start_date DATE ;
2341: l_end_date DATE ;

Line 5007: FROM ams_deliverables_vl

5003: --
5004: CURSOR c_delv_details IS
5005: SELECT actual_avail_from_date
5006: ,actual_avail_to_date
5007: FROM ams_deliverables_vl
5008: WHERE deliverable_id = p_delv_id ;
5009: --
5010: l_start_date DATE ;
5011: l_end_date DATE ;

Line 5649: FROM ams_deliverables_vl

5645: --
5646: CURSOR c_delv_details IS
5647: SELECT actual_avail_from_date
5648: ,actual_avail_to_date
5649: FROM ams_deliverables_vl
5650: WHERE deliverable_id = p_delv_id ;
5651: --
5652: CURSOR c_profile_ques_count IS
5653: SELECT count(1)