APPS.AML_MONITOR_WF dependencies on JTF_RS_RESOURCE_EXTNS

Line 762: from jtf_rs_resource_extns

758:
759:
760: CURSOR c_lead_owner_fullname (c_assign_to_salesforce_id number) is
761: select source_first_name || ' '||source_last_name
762: from jtf_rs_resource_extns
763: where resource_id = c_assign_to_salesforce_id;
764:
765:
766: /* */

Line 769: /* FROM pv_process_rules_b rule, fnd_user usr, jtf_rs_resource_extns res */

765:
766: /* */
767: /* CURSOR c_monitor_owner (c_process_rule_id number) IS */
768: /* SELECT usr.user_name */
769: /* FROM pv_process_rules_b rule, fnd_user usr, jtf_rs_resource_extns res */
770: /* WHERE rule.process_rule_id = c_process_rule_id */
771: /* AND rule.owner_resource_id = res.resource_id */
772: /* and res.user_id = usr.user_id; */
773:

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 2147: from jtf_rs_resource_extns

2143: l_esc_username varchar2(100);
2144:
2145: CURSOR c_esc_username (c_esc_mgr_resource_id number) IS
2146: select source_id, source_name, source_email, user_name
2147: from jtf_rs_resource_extns
2148: where resource_id = c_esc_mgr_resource_id;
2149:
2150:
2151: BEGIN

Line 2566: FROM jtf_rs_resource_extns res

2562: l_resultout varchar2(100);
2563:
2564: CURSOR C_get_current_resource IS
2565: SELECT res.resource_id
2566: FROM jtf_rs_resource_extns res
2567: WHERE res.category = 'EMPLOYEE'
2568: AND res.user_id = fnd_global.user_id;
2569:
2570: CURSOR c_get_group_id(c_resource_id NUMBER) IS

Line 2598: FROM jtf_rs_resource_extns res

2594: -- may not have person_id for all resources. Therefore, get person_id
2595: -- in this cursor, instead of in the above cursor.
2596: CURSOR c_get_person_id(c_resource_id NUMBER) IS
2597: SELECT res.source_id
2598: FROM jtf_rs_resource_extns res
2599: WHERE res.resource_id = c_resource_id;
2600:
2601: BEGIN
2602:

Line 3224: from jtf_rs_resource_extns

3220:
3221:
3222: CURSOR c_lead_owner_fullname (c_assign_to_salesforce_id number) is
3223: select source_first_name || ' '||source_last_name
3224: from jtf_rs_resource_extns
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

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

Line 3243: from jtf_rs_resource_extns

3239:
3240: -- 5/2/03 add cursor
3241: Cursor c_get_resource_info(c_resource_id number) is
3242: select source_id, source_name, source_email, user_name
3243: from jtf_rs_resource_extns
3244: where resource_id = c_resource_id;
3245:
3246: Begin
3247: