DBA Data[Home] [Help]

APPS.AMS_WFCMPAPR_PVT dependencies on AMS_DELIVERABLES_VL

Line 401: FROM ams_deliverables_vl deli

397: WHERE campaign_id = p_activity_id ;
398:
399: CURSOR c_deli_det IS
400: SELECT owner_user_id
401: FROM ams_deliverables_vl deli
402: WHERE deliverable_id = p_activity_id ;
403:
404: CURSOR c_eveh_det IS
405: SELECT owner_user_id

Line 592: FROM ams_deliverables_vl

588:
589: CURSOR c_deli_det IS
590: SELECT fund_source_type,
591: fund_source_id
592: FROM ams_deliverables_vl
593: WHERE deliverable_id = p_activity_id ;
594:
595: CURSOR c_eveh_det IS
596: SELECT fund_source_type_code,

Line 669: FROM ams_deliverables_vl deli

665: WHERE campaign_id = l_source_id ;
666:
667: CURSOR c_deli_det IS
668: SELECT owner_user_id
669: FROM ams_deliverables_vl deli
670: WHERE deliverable_id = l_source_id ;
671:
672: CURSOR c_eveh_det IS
673: SELECT owner_user_id

Line 3533: FROM ams_deliverables_vl dl,fnd_languages lg

3529: dl.description description,
3530: lg.nls_language nls_language,
3531: dl.transaction_currency_code transaction_currency_code,
3532: dl.budget_amount_tc budget_amount_tc
3533: FROM ams_deliverables_vl dl,fnd_languages lg
3534: WHERE dl.deliverable_id = l_my_deliverable_id
3535: AND dl.language_code = lg.language_code ;
3536:
3537: