APPS.JTF_ASSIGN_PUB dependencies on JTF_TASK_RESOURCES_VL

Line 5192: FROM jtf_task_resources_vl

5188: CURSOR check_date_cur(l_resource_id in number,
5189: l_resource_type in varchar2)
5190: IS
5191: SELECT 'Y'
5192: FROM jtf_task_resources_vl
5193: where resource_id = l_resource_id
5194: and resource_type = l_resource_type
5195: and nvl(trunc(end_date_active), trunc(sysdate)) >= trunc(sysdate);
5196:

Line 6607: FROM jtf_task_resources_vl

6603: l_resource_type in varchar2)
6604: IS
6605: SELECT 'Y'
6606: --FROM jtf_rs_all_resources_vl
6607: FROM jtf_task_resources_vl
6608: where resource_id = l_resource_id
6609: and resource_type = l_resource_type
6610: and nvl(trunc(end_date_active), trunc(sysdate)) >= trunc(sysdate);
6611:

Line 7293: FROM jtf_task_resources_vl

7289: l_resource_type in varchar2)
7290: IS
7291: SELECT 'Y'
7292: --FROM jtf_rs_all_resources_vl
7293: FROM jtf_task_resources_vl
7294: where resource_id = l_resource_id
7295: and resource_type = l_resource_type
7296: and nvl(trunc(end_date_active), trunc(sysdate)) >= trunc(sysdate);
7297:

Line 8495: FROM jtf_task_resources_vl

8491: l_resource_type in varchar2)
8492: IS
8493: SELECT 'Y'
8494: --FROM jtf_rs_all_resources_vl
8495: FROM jtf_task_resources_vl
8496: where resource_id = l_resource_id
8497: and resource_type = l_resource_type
8498: and nvl(trunc(end_date_active), trunc(sysdate)) >= trunc(sysdate);
8499:

Line 9615: FROM jtf_task_resources_vl

9611: l_resource_type in varchar2)
9612: IS
9613: SELECT 'Y'
9614: --FROM jtf_rs_all_resources_vl
9615: FROM jtf_task_resources_vl
9616: where resource_id = l_resource_id
9617: and resource_type = l_resource_type
9618: and nvl(trunc(end_date_active), trunc(sysdate)) >= trunc(sysdate);
9619:

Line 10751: FROM jtf_task_resources_vl

10747: l_resource_type in varchar2)
10748: IS
10749: SELECT 'Y'
10750: --FROM jtf_rs_all_resources_vl
10751: FROM jtf_task_resources_vl
10752: where resource_id = l_resource_id
10753: and resource_type = l_resource_type
10754: and nvl(trunc(end_date_active), trunc(sysdate)) >= trunc(sysdate);
10755: