APPS.JTF_TASK_RECURRENCES_PVT dependencies on DUAL

Line 1524: FROM dual;

1520: l_saturday VARCHAR2(1) := p_saturday;
1521: BEGIN
1522: SELECT DECODE (p_occurs_which, 1, 'FIRST', 2, 'SECOND', 3, 'THIRD', 4, 'FOUR', 99, 'LAST')
1523: INTO l_occurs_which
1524: FROM dual;
1525: SELECT DECODE (
1526: p_day_of_week,
1527: 1, 'SUNDAY',
1528: 2, 'MONDAY',

Line 1539: FROM dual;

1535: 8, 'WEEKDAY',
1536: 9, 'WEEKEND'
1537: )
1538: INTO l_day_of_week
1539: FROM dual;
1540: jtf_task_recurrences_pvt.recur_main (
1541: p_occurs_which => l_occurs_which,
1542: p_date_of_month => p_date_of_month,
1543: p_day_of_week => l_day_of_week,

Line 2441: FROM dual;

2437: END;
2438:
2439: SELECT jtf_task_recur_rules_s.nextval
2440: INTO l_recur_id
2441: FROM dual;
2442:
2443: jtf_task_recur_rules_pkg.insert_row (
2444: x_rowid => l_rowid,
2445: x_recurrence_rule_id => l_recur_id,