DBA Data[Home] [Help]

APPS.JTF_RS_ROLE_RELATE_VUHK dependencies on JTF_RS_RESOURCE_EXTNS

Line 1070: FROM jtf_rs_resource_extns

1066:
1067: -- clku, bug 3718575 get the resource category information
1068: CURSOR resource_category_info IS
1069: SELECT category
1070: FROM jtf_rs_resource_extns
1071: where resource_id = P_ROLE_RESOURCE_ID;
1072:
1073: BEGIN
1074: -- Initialize API return status to success

Line 1484: from jtf_rs_resource_extns re, jtf_rs_role_relations rr

1480:
1481: -- clku, bug 3718575 get the resource category information
1482: CURSOR resource_category_info IS
1483: select category
1484: from jtf_rs_resource_extns re, jtf_rs_role_relations rr
1485: where re.resource_id = rr.role_resource_id
1486: and rr.role_relate_id = P_ROLE_RELATE_ID;
1487:
1488: BEGIN

Line 1923: from jtf_rs_resource_extns re, jtf_rs_role_relations rr

1919:
1920: -- clku, bug 3718575 get the resource category information
1921: CURSOR resource_category_info IS
1922: select category
1923: from jtf_rs_resource_extns re, jtf_rs_role_relations rr
1924: where re.resource_id = rr.role_resource_id
1925: and rr.role_relate_id = P_ROLE_RELATE_ID;
1926:
1927: BEGIN