APPS.AMS_SCHEDULERULES_PVT dependencies on DUAL

Line 1242: FROM DUAL

1238: WHERE schedule_id = p_schedule_rec.schedule_id;
1239:
1240: CURSOR c_bud_line IS
1241: SELECT 1
1242: FROM DUAL
1243: WHERE EXISTS(
1244: SELECT activity_budget_id
1245: FROM ozf_act_budgets
1246: WHERE arc_act_budget_used_by = 'CSCH'

Line 1377: -- FROM DUAL

1373: -- WHERE event_offer_id = p_channel_id;
1374:
1375: -- CURSOR c_camp_event IS
1376: -- SELECT 1
1377: -- FROM DUAL
1378: -- WHERE EXISTS(
1379: -- SELECT campaign_id
1380: -- FROM ams_campaigns_vl
1381: -- WHERE media_type_code = 'EVENTS'

Line 1975: FROM DUAL

1971: WHERE schedule_id = p_schedule_id;
1972:
1973: CURSOR c_budget_exist IS
1974: SELECT 1
1975: FROM DUAL
1976: WHERE EXISTS(
1977: SELECT 1
1978: FROM ozf_act_budgets
1979: WHERE arc_act_budget_used_by = 'CSCH'

Line 2702: FROM dual;

2698: WHERE schedule_id = p_schedule_id;
2699:
2700: CURSOR c_media_item_id IS
2701: SELECT JTF_IH_MEDIA_ITEMS_S1.NEXTVAL
2702: FROM dual;
2703:
2704: CURSOR c_interactions_id IS
2705: SELECT jtf_ih_interactions_s1.NEXTVAL
2706: FROM dual;

Line 2706: FROM dual;

2702: FROM dual;
2703:
2704: CURSOR c_interactions_id IS
2705: SELECT jtf_ih_interactions_s1.NEXTVAL
2706: FROM dual;
2707:
2708: CURSOR c_activities_id IS
2709: SELECT JTF_IH_ACTIVITIES_S1.NEXTVAL
2710: FROM dual;

Line 2710: FROM dual;

2706: FROM dual;
2707:
2708: CURSOR c_activities_id IS
2709: SELECT JTF_IH_ACTIVITIES_S1.NEXTVAL
2710: FROM dual;
2711:
2712: l_interaction_rec JTF_IH_PUB.interaction_rec_type;
2713: l_activities JTF_IH_PUB.activity_tbl_type;
2714: l_activity_rec JTF_IH_PUB.activity_rec_type;

Line 4507: FROM DUAL;

4503:
4504:
4505: CURSOR c_batch_id IS
4506: SELECT as_sl_imp_batch_s.NEXTVAL
4507: FROM DUAL;
4508:
4509: CURSOR c_lead_header_id_csr IS
4510: SELECT AS_IMPORT_INTERFACE_S.NEXTVAL
4511: FROM dual;

Line 4511: FROM dual;

4507: FROM DUAL;
4508:
4509: CURSOR c_lead_header_id_csr IS
4510: SELECT AS_IMPORT_INTERFACE_S.NEXTVAL
4511: FROM dual;
4512:
4513: CURSOR c_lead_header_id_exists_csr (l_id IN NUMBER) IS
4514: SELECT 1 FROM dual
4515: WHERE EXISTS (SELECT 1 FROM as_import_interface

Line 4514: SELECT 1 FROM dual

4510: SELECT AS_IMPORT_INTERFACE_S.NEXTVAL
4511: FROM dual;
4512:
4513: CURSOR c_lead_header_id_exists_csr (l_id IN NUMBER) IS
4514: SELECT 1 FROM dual
4515: WHERE EXISTS (SELECT 1 FROM as_import_interface
4516: WHERE import_interface_id = l_id);
4517:
4518: CURSOR c_lead_line_id_csr IS

Line 4520: FROM dual;

4516: WHERE import_interface_id = l_id);
4517:
4518: CURSOR c_lead_line_id_csr IS
4519: SELECT AS_IMP_LINES_INTERFACE_S.NEXTVAL
4520: FROM dual;
4521:
4522: CURSOR c_lead_line_id_exists_csr (l_id IN NUMBER) IS
4523: SELECT 1 FROM dual
4524: WHERE EXISTS (SELECT 1 FROM as_imp_lines_interface

Line 4523: SELECT 1 FROM dual

4519: SELECT AS_IMP_LINES_INTERFACE_S.NEXTVAL
4520: FROM dual;
4521:
4522: CURSOR c_lead_line_id_exists_csr (l_id IN NUMBER) IS
4523: SELECT 1 FROM dual
4524: WHERE EXISTS (SELECT 1 FROM as_imp_lines_interface
4525: WHERE imp_lines_interface_id = l_id);
4526:
4527: CURSOR c_loaded_rows_for_lead (batch_id_in IN NUMBER) IS