DBA Data[Home] [Help]

APPS.OKL_CS_LC_CONTRACT_PVT dependencies on JTF_RS_GROUP_MEMBERS

Line 1002: FROM jtf_rs_group_members rgm,

998: -- stored in pl/sql global table and this table is used for
999: -- subsequent contracts in the same session.
1000: CURSOR res_grp_csr IS
1001: SELECT rgm.group_id
1002: FROM jtf_rs_group_members rgm,
1003: jtf_rs_role_relations rrr,
1004: jtf_rs_roles_b rr,
1005: jtf_rs_groups_b rgb
1006: WHERE rgm.resource_id = g_user_resource_id

Line 1020: FROM jtf_rs_group_members rgm,

1016: AND rrr.role_id = rr.role_id
1017: AND rr.role_type_code = 'CONTRACTS'
1018: UNION
1019: SELECT rgd.parent_group_id
1020: FROM jtf_rs_group_members rgm,
1021: jtf_rs_groups_denorm rgd,
1022: jtf_rs_role_relations rrr,
1023: jtf_rs_roles_b rr,
1024: jtf_rs_groups_b rgb