APPS.AMS_DMSELECTION_PVT dependencies on DUAL

Line 1991: FROM dual

1987: IF l_is_b2b THEN
1988: --UPDATE ams_dm_target_stg t
1989: UPDATE ams_dm_target_stg_gt t
1990: SET target_flag = (SELECT L_POSITIVE_TARGET_VALUE
1991: FROM dual
1992: -- choang - 21-nov-2003 - bug 3275817
1993: -- changed to not exists and having clause
1994: WHERE NOT EXISTS (SELECT 1
1995: -- changed rosharma 19-jun-2003 bug # 3004453

Line 2018: FROM dual

2014: ELSE
2015: -- UPDATE ams_dm_target_stg t
2016: UPDATE ams_dm_target_stg_gt t
2017: SET target_flag = (SELECT L_POSITIVE_TARGET_VALUE
2018: FROM dual
2019: -- choang - 21-nov-2003 - bug 3275817
2020: -- changed to not exists and having clause
2021: WHERE NOT EXISTS (SELECT 1
2022: -- changed rosharma 19-jun-2003 bug # 3004453

Line 2039: FROM dual

2035: ELSIF l_model_rec.model_type IN ('EMAIL', 'DIRECTMAIL', 'TELEMARKETING') THEN
2036: -- UPDATE ams_dm_target_stg t
2037: UPDATE ams_dm_target_stg_gt t
2038: SET target_flag = (SELECT L_POSITIVE_TARGET_VALUE
2039: FROM dual
2040: WHERE EXISTS (SELECT 1
2041: FROM ams_campaign_schedules_b c, jtf_ih_interactions i,
2042: jtf_ih_results_b r, ams_list_select_actions l
2043: WHERE c.schedule_id = l.incl_object_id

Line 2078: l_sql := l_sql || ' FROM dual WHERE EXISTS (SELECT 1';

2074:
2075: -- l_sql := 'UPDATE ams_dm_target_stg t';
2076: l_sql := 'UPDATE ams_dm_target_stg_gt t';
2077: l_sql := l_sql || ' SET t.target_flag = (SELECT ''' || L_POSITIVE_TARGET_VALUE || '''';
2078: l_sql := l_sql || ' FROM dual WHERE EXISTS (SELECT 1';
2079:
2080: IF l_data_source_id = l_target_source_id THEN
2081: l_sql := l_sql || ' FROM ams_dm_target_values_b tv, ' || l_target_source_object_full;
2082: ELSE

Line 2149: FROM dual

2145: IF l_is_b2b AND l_is_org_prod_affn = false THEN
2146: -- UPDATE ams_dm_target_stg t
2147: UPDATE ams_dm_target_stg_gt t
2148: SET target_flag = (SELECT L_POSITIVE_TARGET_VALUE
2149: FROM dual
2150: WHERE EXISTS (SELECT 1
2151: FROM AMS_ACT_PRODUCTS aa, OE_ORDER_HEADERS_ALL oh, OE_ORDER_LINES_ALL ol,
2152: hz_cust_account_roles hcr, hz_relationships hpr
2153: WHERE aa.ARC_ACT_PRODUCT_USED_BY = 'MODL'

Line 2186: FROM dual

2182: ELSE
2183: -- UPDATE ams_dm_target_stg t
2184: UPDATE ams_dm_target_stg_gt t
2185: SET target_flag = (SELECT L_POSITIVE_TARGET_VALUE
2186: FROM dual
2187: WHERE EXISTS (SELECT 1
2188: FROM AMS_ACT_PRODUCTS aa,
2189: OE_ORDER_HEADERS_ALL oh,
2190: OE_ORDER_LINES_ALL ol,

Line 2469: FROM dual

2465:
2466: IF l_object_rec.model_type = 'LOYALTY' THEN
2467: UPDATE /*+ index(t AMS_DM_SOURCE_U2) */ ams_dm_source t
2468: SET target_value = (SELECT L_POSITIVE_TARGET_VALUE
2469: FROM dual
2470: WHERE EXISTS (SELECT 1
2471: FROM hz_cust_accounts c, hz_suspension_activity s
2472: WHERE c.party_id = t.party_id
2473: AND s.cust_account_id = c.cust_account_id

Line 2481: FROM dual

2477: AND used_for_object_id = p_object_id;
2478: ELSIF l_object_rec.model_type IN ('EMAIL', 'DIRECTMAIL', 'TELEMARKETING') THEN
2479: UPDATE /*+ index(t AMS_DM_SOURCE_U2) */ ams_dm_source t
2480: SET target_value = (SELECT L_POSITIVE_TARGET_VALUE
2481: FROM dual
2482: WHERE EXISTS (SELECT 1
2483: FROM ams_campaign_schedules_b c,
2484: jtf_ih_interactions i,
2485: ams_list_select_actions l