DBA Data[Home] [Help]

APPS.JTF_TASK_SYNC_UPGRADE_PKG dependencies on DUAL

Line 251: FROM DUAL;

247: IF l_output_dates_tbl.EXISTS(i)
248: THEN
249: SELECT jta_task_exclusions_s.NEXTVAL
250: INTO l_task_exclusion_id
251: FROM DUAL;
252:
253: IF TRUNC(l_output_dates_tbl(i)) = l_output_dates_tbl(i) AND
254: l_time <> '00:00:00'
255: THEN

Line 501: FROM DUAL;

497: IF NOT (l_duplicate_found OR l_start_date_or_extra_modified)
498: THEN
499: SELECT jta_task_exclusions_s.NEXTVAL
500: INTO l_task_exclusion_id
501: FROM DUAL;
502:
503: jta_task_exclusions_pkg.insert_row (
504: p_task_exclusion_id => l_task_exclusion_id,
505: p_task_id => rec_updated_appts.task_id,