APPS.FTE_SEL_GROUPS_PKG dependencies on FTE_SEL_GROUP_ASSIGNMENTS

Line 37: FROM fte_sel_group_assignments ga,

33: p_assignee_id IN NUMBER) RETURN BOOLEAN IS
34:
35: CURSOR c_assign IS
36: SELECT start_date, end_date
37: FROM fte_sel_group_assignments ga,
38: fte_sel_groups gr
39: WHERE gr.group_id = ga.group_id AND
40: gr.group_id <> p_group_id AND
41: ga.customer_id = p_assignee_id AND

Line 45: FROM fte_sel_group_assignments ga,

41: ga.customer_id = p_assignee_id AND
42: p_assignee_type = 'CUST'
43: UNION ALL
44: SELECT start_date, end_date
45: FROM fte_sel_group_assignments ga,
46: fte_sel_groups gr
47: WHERE gr.group_id = ga.group_id AND
48: gr.group_id <> p_group_id AND
49: ga.customer_site_id = p_assignee_id AND

Line 53: FROM fte_sel_group_assignments ga,

49: ga.customer_site_id = p_assignee_id AND
50: p_assignee_type = 'CUST_SITE'
51: UNION ALL
52: SELECT start_date, end_date
53: FROM fte_sel_group_assignments ga,
54: fte_sel_groups gr
55: WHERE gr.group_id = ga.group_id AND
56: gr.group_id <> p_group_id AND
57: ga.organization_id = p_assignee_id AND

Line 61: FROM fte_sel_group_assignments ga,

57: ga.organization_id = p_assignee_id AND
58: p_assignee_type = 'ORG'
59: UNION ALL
60: SELECT start_date, end_date
61: FROM fte_sel_group_assignments ga,
62: fte_sel_groups gr
63: WHERE gr.group_id = ga.group_id AND
64: gr.group_id <> p_group_id AND
65: ga.organization_id is null AND

Line 156: FROM fte_sel_group_assignments

152: group_id <> p_group_id;
153:
154: CURSOR c_assignee IS
155: SELECT organization_id, customer_id, customer_site_id
156: FROM fte_sel_group_assignments
157: WHERE group_id = p_group_id;
158:
159: l_name VARCHAR2(30);
160: l_overlap BOOLEAN;

Line 274: group_id NOT IN (select group_id from fte_sel_group_assignments

270: WHERE name = p_group_name and
271: object_id = 1 and
272: nvl(end_date, sysdate) >= sysdate and
273: p_assignee_type = 'CUST' and
274: group_id NOT IN (select group_id from fte_sel_group_assignments
275: where customer_id = p_assignee_id or -- already
276: organization_id is not null or -- ORG
277: organization_id is null and -- ENT
278: customer_id is null and

Line 287: group_id NOT IN (select group_id from fte_sel_group_assignments

283: WHERE name = p_group_name and
284: object_id = 1 and
285: nvl(end_date, sysdate) >= sysdate and
286: p_assignee_type = 'CUST_SITE' and
287: group_id NOT IN (select group_id from fte_sel_group_assignments
288: where customer_site_id = p_assignee_id or -- already
289: organization_id is not null or -- ORG
290: organization_id is null and -- ENT
291: customer_id is null and

Line 300: group_id NOT IN (select group_id from fte_sel_group_assignments

296: WHERE name = p_group_name and
297: object_id = 1 and
298: nvl(end_date, sysdate) >= sysdate and
299: p_assignee_type = 'ORG' and
300: group_id NOT IN (select group_id from fte_sel_group_assignments
301: where organization_id = p_assignee_id or -- already
302: customer_id is not null or -- CUST
303: customer_site_id is not null) -- CUST_SITE
304: UNION ALL

Line 311: group_id NOT IN (select group_id from fte_sel_group_assignments

307: WHERE name = p_group_name and
308: object_id = 1 and
309: nvl(end_date, sysdate) >= sysdate and
310: p_assignee_type = 'ENT' and
311: group_id NOT IN (select group_id from fte_sel_group_assignments
312: where customer_id is not null or -- CUST
313: customer_site_id is not null or -- CUST_SITE
314: organization_id is null and -- already
315: customer_id is null and