499: -- Get Schedule Details
500: CURSOR C_GET_SCHEDULE_DETAILS(p_schedule_id NUMBER)
501: IS
502: SELECT activity_id
503: FROM AMS_CAMPAIGN_SCHEDULES_B
504: WHERE SCHEDULE_ID = p_schedule_id;
505:
506:
507: CURSOR C_GET_RULE_DTLS(p_schedule_id NUMBER)
507: CURSOR C_GET_RULE_DTLS(p_schedule_id NUMBER)
508: IS
509: SELECT rule_id,rule_type
510: FROM ams_tcop_fr_rules_setup rule,
511: ams_campaign_schedules_b schedule,
512: ams_tcop_fr_periods_b period
513: WHERE rule.ENABLED_FLAG = 'Y'
514: AND (rule.CHANNEL_ID is null
515: OR (rule.CHANNEL_ID = schedule.activity_id) )