APPS.JTF_ASSIGN_PUB dependencies on JTF_TASK_RESOURCES_VL

Line 5256: FROM jtf_task_resources_vl

5252: CURSOR check_date_cur(l_resource_id in number,
5253: l_resource_type in varchar2)
5254: IS
5255: SELECT 'Y'
5256: FROM jtf_task_resources_vl
5257: where resource_id = l_resource_id
5258: and resource_type = l_resource_type
5259: and nvl(trunc(end_date_active), trunc(sysdate)) >= trunc(sysdate);
5260:

Line 6671: FROM jtf_task_resources_vl

6667: l_resource_type in varchar2)
6668: IS
6669: SELECT 'Y'
6670: --FROM jtf_rs_all_resources_vl
6671: FROM jtf_task_resources_vl
6672: where resource_id = l_resource_id
6673: and resource_type = l_resource_type
6674: and nvl(trunc(end_date_active), trunc(sysdate)) >= trunc(sysdate);
6675:

Line 7357: FROM jtf_task_resources_vl

7353: l_resource_type in varchar2)
7354: IS
7355: SELECT 'Y'
7356: --FROM jtf_rs_all_resources_vl
7357: FROM jtf_task_resources_vl
7358: where resource_id = l_resource_id
7359: and resource_type = l_resource_type
7360: and nvl(trunc(end_date_active), trunc(sysdate)) >= trunc(sysdate);
7361:

Line 8559: FROM jtf_task_resources_vl

8555: l_resource_type in varchar2)
8556: IS
8557: SELECT 'Y'
8558: --FROM jtf_rs_all_resources_vl
8559: FROM jtf_task_resources_vl
8560: where resource_id = l_resource_id
8561: and resource_type = l_resource_type
8562: and nvl(trunc(end_date_active), trunc(sysdate)) >= trunc(sysdate);
8563:

Line 9679: FROM jtf_task_resources_vl

9675: l_resource_type in varchar2)
9676: IS
9677: SELECT 'Y'
9678: --FROM jtf_rs_all_resources_vl
9679: FROM jtf_task_resources_vl
9680: where resource_id = l_resource_id
9681: and resource_type = l_resource_type
9682: and nvl(trunc(end_date_active), trunc(sysdate)) >= trunc(sysdate);
9683:

Line 10815: FROM jtf_task_resources_vl

10811: l_resource_type in varchar2)
10812: IS
10813: SELECT 'Y'
10814: --FROM jtf_rs_all_resources_vl
10815: FROM jtf_task_resources_vl
10816: where resource_id = l_resource_id
10817: and resource_type = l_resource_type
10818: and nvl(trunc(end_date_active), trunc(sysdate)) >= trunc(sysdate);
10819: