DBA Data[Home] [Help]

APPS.AML_MONITOR_WF dependencies on JTF_RS_REP_MANAGERS

Line 776: from jtf_rs_rep_managers mgr, fnd_user usr, jtf_rs_resource_extns res

772: /* and res.user_id = usr.user_id; */
773:
774: Cursor c_get_mgr_username (c_resource_id number, c_group_id number) is
775: select usr.user_name, res.resource_id
776: from jtf_rs_rep_managers mgr, fnd_user usr, jtf_rs_resource_extns res
777: where mgr.manager_person_id = res.source_id
778: and res.user_id = usr.user_id
779: and mgr.resource_id= c_resource_id
780: and mgr.group_id = c_group_id

Line 3229: from jtf_rs_rep_managers mgr, fnd_user usr, jtf_rs_resource_extns res

3225: where resource_id = c_assign_to_salesforce_id;
3226:
3227: Cursor c_get_mgr_username (c_resource_id number, c_group_id number) is
3228: select usr.user_name, res.resource_id
3229: from jtf_rs_rep_managers mgr, fnd_user usr, jtf_rs_resource_extns res
3230: where mgr.manager_person_id = res.source_id
3231: and res.user_id = usr.user_id
3232: and mgr.resource_id= c_resource_id
3233: and mgr.group_id = c_group_id