DBA Data[Home] [Help]

APPS.LNS_WORK_FLOW dependencies on JTF_RS_ROLES_B

Line 1007: ,jtf_rs_roles_b rol

1003: CURSOR csr_loan_role_users IS
1004: SELECT fndu.user_name
1005: ,fndu.user_id
1006: FROM jtf_rs_role_relations rel
1007: ,jtf_rs_roles_b rol
1008: ,jtf_rs_resource_extns res
1009: ,fnd_user fndu
1010: WHERE rel.role_id = rol.role_id
1011: AND rel.delete_flag <> 'Y'

Line 3012: jtf_rs_roles_b rol

3008: (select
3009: rol.manager_flag,rel.role_resource_id
3010: FROM
3011: jtf_rs_role_relations rel ,
3012: jtf_rs_roles_b rol
3013: where rel.role_id = rol.role_id
3014: and rel.delete_flag <> 'Y'
3015: and sysdate between nvl(rel.start_date_active,sysdate) and nvl(rel.end_date_active,sysdate)
3016: and rol.role_type_code = 'LOANS'