DBA Data[Home] [Help]

APPS.OKL_CS_LC_CONTRACT_PVT dependencies on JTF_RS_GROUP_MEMBERS

Line 1040: FROM jtf_rs_group_members rgm,

1036: -- stored in pl/sql global table and this table is used for
1037: -- subsequent contracts in the same session.
1038: CURSOR res_grp_csr IS
1039: SELECT rgm.group_id
1040: FROM jtf_rs_group_members rgm,
1041: jtf_rs_role_relations rrr,
1042: jtf_rs_roles_b rr,
1043: jtf_rs_groups_b rgb
1044: WHERE rgm.resource_id = g_user_resource_id

Line 1058: FROM jtf_rs_group_members rgm,

1054: AND rrr.role_id = rr.role_id
1055: AND rr.role_type_code = 'CONTRACTS'
1056: UNION
1057: SELECT rgd.parent_group_id
1058: FROM jtf_rs_group_members rgm,
1059: jtf_rs_groups_denorm rgd,
1060: jtf_rs_role_relations rrr,
1061: jtf_rs_roles_b rr,
1062: jtf_rs_groups_b rgb