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

2443: END;
2444:
2445: SELECT jtf_task_recur_rules_s.nextval
2446: INTO l_recur_id
2447: FROM dual;
2448:
2449: jtf_task_recur_rules_pkg.insert_row (
2450: x_rowid => l_rowid,
2451: x_recurrence_rule_id => l_recur_id,