DBA Data[Home] [Help]

APPS.AMS_CAMP_SCHEDULE_PVT dependencies on AMS_CAMPAIGNS_ALL_B

Line 1982: l_table_name := 'ams_campaigns_all_b' ;

1978: x_return_status := FND_API.g_ret_sts_success;
1979:
1980: -- Check Campaign Id
1981: IF p_schedule_rec.campaign_id <> FND_API.g_miss_num THEN
1982: l_table_name := 'ams_campaigns_all_b' ;
1983: l_pk_name := 'campaign_id' ;
1984: l_pk_value := p_schedule_rec.campaign_id ;
1985: l_pk_data_type := AMS_Utility_PVT.G_NUMBER ;
1986: l_additional_where_clause := NULL ;

Line 3216: FROM ams_campaigns_all_b

3212: l_pk_data_type VARCHAR2(30);
3213:
3214: CURSOR c_camp_status IS
3215: SELECT status_code,rollup_type
3216: FROM ams_campaigns_all_b
3217: WHERE campaign_id = p_schedule_rec.campaign_id ;
3218: l_status_code VARCHAR2(30);
3219: l_rollup_type VARCHAR2(30);
3220: