DBA Data[Home] [Help]

APPS.LNS_WORK_FLOW dependencies on JTF_RS_ROLE_RELATIONS

Line 1006: FROM jtf_rs_role_relations rel

1002:
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

Line 3011: jtf_rs_role_relations rel ,

3007: from
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)