DBA Data[Home] [Help]

APPS.CSL_JTF_TASK_ASS_ACC_PKG dependencies on FND_PROFILE

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

829: WHERE acc.task_assignment_id = jta.task_assignment_id
830: AND jt.task_id = jta.task_id
831: AND jts.task_status_id = jt.task_status_id
832: AND jta_jts.task_status_id = jta.assignment_status_id
833: AND (NVL(jt.scheduled_start_date, SYSDATE) < (SYSDATE - TO_NUMBER(FND_PROFILE.Value('CSL_APPL_HISTORY_IN_DAYS'))))
834: AND (NVL(jts.cancelled_flag,'N') = 'Y'
835: OR NVL(jts.closed_flag, 'N') = 'Y'
836: OR NVL(jts.completed_flag, 'N') = 'Y'
837: OR NVL(jts.rejected_flag, 'N') = 'Y'