APPS.CSM_EMAIL_QUERY_PKG dependencies on JTF_RS_RESOURCE_EXTNS

Line 33: jtf_rs_resource_extns

29: IS
30: CURSOR c_get_resource(p_user_id NUMBER)
31: IS
32: select RESOURCE_ID FROM
33: jtf_rs_resource_extns
34: WHERE USER_ID = p_user_id;
35:
36: l_resource_id NUMBER := NULL;
37: BEGIN

Line 583: FROM jtf_rs_resource_extns rs,

579: CURSOR c_groups(p_user_id NUMBER)
580: IS
581: SELECT gb.group_id,
582: gtl.group_name
583: FROM jtf_rs_resource_extns rs,
584: jtf_rs_groups_b gb,
585: jtf_rs_groups_tl gtl,
586: jtf_rs_group_members gm,
587: jtf_rs_roles_b rb,

Line 616: JTF_RS_RESOURCE_EXTNS RS,

612: CURSOR c_group_members(p_group_id NUMBER)
613: is
614: SELECT fusr.user_id
615: from FND_USER FUSR,
616: JTF_RS_RESOURCE_EXTNS RS,
617: JTF_RS_GROUP_MEMBERS GM
618: where gm.group_id = p_group_id
619: AND gm.delete_flag = 'N'
620: AND rs.resource_id = gm.resource_id

Line 629: JTF_RS_RESOURCE_EXTNS RS,

625: and (FUSR.END_DATE is null or FUSR.END_DATE >= sysdate);
626:
627: /* SELECT fusr.user_id
628: from FND_USER FUSR,
629: JTF_RS_RESOURCE_EXTNS RS,
630: jtf_rs_groups_b gb,
631: JTF_RS_GROUP_MEMBERS GM
632: jtf_rs_roles_b rb,
633: jtf_rs_role_relations rr_grp,

Line 828: FROM jtf_rs_resource_extns res,

824: ctl.task_name as subject,
825: jtstl.name task_status,
826: to_char(CSM_EMAIL_QUERY_PKG.ADJUST_TIME(ct.scheduled_start_date), '''|| g_date_format_mask ||''') scheduled_start_date,
827: to_char(CSM_EMAIL_QUERY_PKG.ADJUST_TIME(ct.scheduled_end_date), '''|| g_date_format_mask ||''') scheduled_end_date
828: FROM jtf_rs_resource_extns res,
829: jtf_task_assignments a,
830: jtf_tasks_b ct,
831: jtf_tasks_tl ctl,
832: cs_incidents_all_b cia,

Line 1516: jtf_rs_resource_extns rs,

1512: ADJUST_TIME(ntb.entered_date) entered_date
1513: FROM jtf_tasks_b tsk,
1514: jtf_notes_b ntb,
1515: jtf_notes_tl nttl,
1516: jtf_rs_resource_extns rs,
1517: fnd_lookup_values lkp
1518: WHERE tsk.task_number = p_task_number
1519: AND ntb.source_object_id = tsk.task_id
1520: AND ntb.source_object_code = 'TASK'

Line 1714: jtf_rs_resource_extns rs,

1710: ADJUST_TIME(ntb.entered_date) entered_date
1711: FROM cs_incidents_all_b cs,
1712: jtf_notes_b ntb,
1713: jtf_notes_tl nttl,
1714: jtf_rs_resource_extns rs,
1715: fnd_lookup_values lkp
1716: WHERE cs.incident_number = p_incident_number
1717: AND ntb.source_object_id = cs.incident_id
1718: AND ntb.source_object_code = 'SR'

Line 2551: FROM jtf_rs_resource_extns

2547: l_required_parts_tbl(1).quantity := NULL;
2548:
2549: --Set the Search PArams
2550: SELECT resource_id INTO l_resource_id
2551: FROM jtf_rs_resource_extns
2552: WHERE user_id = G_USER_ID
2553: AND category = 'EMPLOYEE';
2554:
2555: l_search_params_rec.search_method := NULL;