DBA Data[Home] [Help]

APPS.JTF_ASSIGN_PUB dependencies on JTF_RS_WEB_AVAILABLE_V

Line 2743: FROM jtf_rs_web_available_v

2739:
2740:
2741: CURSOR cur_web_availability (p_res_id NUMBER, p_res_type VARCHAR2) IS
2742: SELECT resource_id
2743: FROM jtf_rs_web_available_v
2744: WHERE resource_id = p_res_id AND
2745: category = p_res_type;
2746:
2747:

Line 3769: FROM jtf_rs_web_available_v

3765:
3766:
3767: CURSOR cur_web_availability (p_res_id NUMBER, p_res_type VARCHAR2) IS
3768: SELECT resource_id
3769: FROM jtf_rs_web_available_v
3770: WHERE resource_id = p_res_id AND
3771: category = p_res_type;
3772:
3773:

Line 5207: FROM jtf_rs_web_available_v

5203:
5204:
5205: CURSOR cur_web_availability (p_res_id NUMBER, p_res_type VARCHAR2) IS
5206: SELECT resource_id
5207: FROM jtf_rs_web_available_v
5208: WHERE resource_id = p_res_id AND
5209: category = p_res_type;
5210:
5211:

Line 9605: FROM jtf_rs_web_available_v

9601:
9602:
9603: CURSOR cur_web_availability (p_res_id NUMBER, p_res_type VARCHAR2) IS
9604: SELECT resource_id
9605: FROM jtf_rs_web_available_v
9606: WHERE resource_id = p_res_id AND
9607: category = p_res_type;
9608:
9609: --Bug# 4455803 MOAC.