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
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,
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
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: