DBA Data[Home] [Help]

APPS.CSL_JTF_TASKS_ACC_PKG dependencies on FND_PROFILE

Line 954: AND (NVL(jt.scheduled_start_date, SYSDATE) < (SYSDATE - TO_NUMBER(FND_PROFILE.Value('CSL_APPL_HISTORY_IN_DAYS'))))

950: jtf_tasks_b jt,
951: jtf_task_statuses_b jts
952: WHERE acc.task_id = jt.task_id
953: AND jts.task_status_id = jt.task_status_id
954: AND (NVL(jt.scheduled_start_date, SYSDATE) < (SYSDATE - TO_NUMBER(FND_PROFILE.Value('CSL_APPL_HISTORY_IN_DAYS'))))
955: AND (NVL(jts.cancelled_flag,'N') = 'Y'
956: OR NVL(jts.closed_flag, 'N') = 'Y'
957: OR NVL(jts.completed_flag, 'N') = 'Y'
958: OR NVL(jts.rejected_flag, 'N') = 'Y')