eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_CMGT_WF_ENGINE dependencies on JTF_RS_ROLES_VL

Line 407: jtf_rs_roles_vl b,

403:
404: CURSOR c_get_resource_id IS
405: SELECT c.resource_id, c.source_id --employee id
406: FROM jtf_rs_role_relations a,
407: jtf_rs_roles_vl b,
408: jtf_rs_resource_extns_vl c
409: WHERE a.role_resource_type = 'RS_INDIVIDUAL'
410: AND a.role_resource_id = c.resource_id
411: AND a.role_id = b.role_id

Line 498: jtf_rs_roles_vl b,

494: BEGIN
495: SELECT c.resource_id
496: INTO l_resource_id
497: FROM jtf_rs_role_relations a,
498: jtf_rs_roles_vl b,
499: jtf_rs_resource_extns_vl c
500: WHERE a.role_resource_type = 'RS_INDIVIDUAL'
501: AND a.role_resource_id = c.resource_id
502: AND a.role_id = b.role_id

Line 927: jtf_rs_roles_vl b,

923: BEGIN
924: SELECT 'X'
925: INTO l_dummy
926: FROM jtf_rs_role_relations a,
927: jtf_rs_roles_vl b,
928: jtf_rs_resource_extns_vl c
929: WHERE a.role_resource_type = 'RS_INDIVIDUAL'
930: AND a.role_resource_id = c.resource_id
931: AND c.resource_id = l_credit_analyst_id