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 2714: FROM dual;

2710: WHERE schedule_id = p_schedule_id;
2711:
2712: CURSOR c_media_item_id IS
2713: SELECT JTF_IH_MEDIA_ITEMS_S1.NEXTVAL
2714: FROM dual;
2715:
2716: CURSOR c_interactions_id IS
2717: SELECT jtf_ih_interactions_s1.NEXTVAL
2718: FROM dual;

Line 2718: FROM dual;

2714: FROM dual;
2715:
2716: CURSOR c_interactions_id IS
2717: SELECT jtf_ih_interactions_s1.NEXTVAL
2718: FROM dual;
2719:
2720: CURSOR c_activities_id IS
2721: SELECT JTF_IH_ACTIVITIES_S1.NEXTVAL
2722: FROM dual;

Line 2722: FROM dual;

2718: FROM dual;
2719:
2720: CURSOR c_activities_id IS
2721: SELECT JTF_IH_ACTIVITIES_S1.NEXTVAL
2722: FROM dual;
2723:
2724: l_interaction_rec JTF_IH_PUB.interaction_rec_type;
2725: l_activities JTF_IH_PUB.activity_tbl_type;
2726: l_activity_rec JTF_IH_PUB.activity_rec_type;

Line 4537: FROM DUAL;

4533:
4534:
4535: CURSOR c_batch_id IS
4536: SELECT as_sl_imp_batch_s.NEXTVAL
4537: FROM DUAL;
4538:
4539: CURSOR c_lead_header_id_csr IS
4540: SELECT AS_IMPORT_INTERFACE_S.NEXTVAL
4541: FROM dual;

Line 4541: FROM dual;

4537: FROM DUAL;
4538:
4539: CURSOR c_lead_header_id_csr IS
4540: SELECT AS_IMPORT_INTERFACE_S.NEXTVAL
4541: FROM dual;
4542:
4543: CURSOR c_lead_header_id_exists_csr (l_id IN NUMBER) IS
4544: SELECT 1 FROM dual
4545: WHERE EXISTS (SELECT 1 FROM as_import_interface

Line 4544: SELECT 1 FROM dual

4540: SELECT AS_IMPORT_INTERFACE_S.NEXTVAL
4541: FROM dual;
4542:
4543: CURSOR c_lead_header_id_exists_csr (l_id IN NUMBER) IS
4544: SELECT 1 FROM dual
4545: WHERE EXISTS (SELECT 1 FROM as_import_interface
4546: WHERE import_interface_id = l_id);
4547:
4548: CURSOR c_lead_line_id_csr IS

Line 4550: FROM dual;

4546: WHERE import_interface_id = l_id);
4547:
4548: CURSOR c_lead_line_id_csr IS
4549: SELECT AS_IMP_LINES_INTERFACE_S.NEXTVAL
4550: FROM dual;
4551:
4552: CURSOR c_lead_line_id_exists_csr (l_id IN NUMBER) IS
4553: SELECT 1 FROM dual
4554: WHERE EXISTS (SELECT 1 FROM as_imp_lines_interface

Line 4553: SELECT 1 FROM dual

4549: SELECT AS_IMP_LINES_INTERFACE_S.NEXTVAL
4550: FROM dual;
4551:
4552: CURSOR c_lead_line_id_exists_csr (l_id IN NUMBER) IS
4553: SELECT 1 FROM dual
4554: WHERE EXISTS (SELECT 1 FROM as_imp_lines_interface
4555: WHERE imp_lines_interface_id = l_id);
4556:
4557: CURSOR c_loaded_rows_for_lead (batch_id_in IN NUMBER) IS