DBA Data[Home] [Help]

APPS.OZF_MULTI_CURR_MIG_PVT dependencies on AMS_CAMPAIGNS_VL

Line 149: FROM ams_campaigns_vl

145: fund_request_currency_code = DECODE(plan_type,'OFFR', (SELECT NVL(transaction_currency_code,fund_request_curr_code)
146: FROM ozf_offers
147: WHERE qp_list_header_id=plan_id)
148: ,'CAMP', (SELECT transaction_currency_code
149: FROM ams_campaigns_vl
150: WHERE campaign_id = plan_id)
151: ,'CSCH', (SELECT transaction_currency_code
152: FROM ams_campaign_schedules_vl
153: WHERE schedule_id = plan_id)

Line 191: FROM ams_campaigns_vl

187: FROM ozf_offers
188: WHERE qp_list_header_id=plan_id)
189: )
190: ,'CAMP', (SELECT transaction_currency_code
191: FROM ams_campaigns_vl
192: WHERE campaign_id = plan_id)
193: ,'CSCH', (SELECT transaction_currency_code
194: FROM ams_campaign_schedules_vl
195: WHERE schedule_id = plan_id)