APPS.JTF_RS_WF_INTEGRATION_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 23: from jtf_rs_resource_extns

19: ) IS
20:
21: cursor res_cur IS
22: select user_id
23: from jtf_rs_resource_extns
24: where resource_id = p_resource_id;
25:
26: l_user_id number;
27:

Line 62: l_category jtf_rs_resource_extns.category%TYPE;

58: l_role_name wf_local_roles.name%TYPE;
59: l_orig_system wf_local_roles.orig_system%TYPE;
60: l_orig_system_id wf_local_roles.orig_system_id%TYPE;
61:
62: l_category jtf_rs_resource_extns.category%TYPE;
63: l_source_id jtf_rs_resource_extns.source_id%TYPE;
64: l_person_party_id jtf_rs_resource_extns.person_party_id%TYPE;
65: l_party_id hz_parties.party_id%TYPE;
66:

Line 63: l_source_id jtf_rs_resource_extns.source_id%TYPE;

59: l_orig_system wf_local_roles.orig_system%TYPE;
60: l_orig_system_id wf_local_roles.orig_system_id%TYPE;
61:
62: l_category jtf_rs_resource_extns.category%TYPE;
63: l_source_id jtf_rs_resource_extns.source_id%TYPE;
64: l_person_party_id jtf_rs_resource_extns.person_party_id%TYPE;
65: l_party_id hz_parties.party_id%TYPE;
66:
67: cursor res_cur IS

Line 64: l_person_party_id jtf_rs_resource_extns.person_party_id%TYPE;

60: l_orig_system_id wf_local_roles.orig_system_id%TYPE;
61:
62: l_category jtf_rs_resource_extns.category%TYPE;
63: l_source_id jtf_rs_resource_extns.source_id%TYPE;
64: l_person_party_id jtf_rs_resource_extns.person_party_id%TYPE;
65: l_party_id hz_parties.party_id%TYPE;
66:
67: cursor res_cur IS
68: select category, source_id, person_party_id

Line 69: from jtf_rs_resource_extns

65: l_party_id hz_parties.party_id%TYPE;
66:
67: cursor res_cur IS
68: select category, source_id, person_party_id
69: from jtf_rs_resource_extns
70: where resource_id = p_resource_id;
71:
72: cursor res_wfrole_cur IS
73: select name, orig_system, orig_system_id

Line 248: jtf_rs_resource_extns res

244: /* Cursor to get the party id of the employee */
245: cursor emp_party_id_cur IS
246: select ppf.party_id
247: from per_all_people_f ppf,
248: jtf_rs_resource_extns res
249: where res.category = 'EMPLOYEE'
250: and res.source_id = ppf.person_id
251: and res.resource_id = p_resource_id
252: order by ppf.effective_start_date desc;

Line 257: from jtf_rs_resource_extns res

253:
254: /* Cursor to get the party id of the party/partner */
255: cursor partner_party_id_cur IS
256: select res.source_id
257: from jtf_rs_resource_extns res
258: where res.resource_id = p_resource_id;
259:
260: l_person_party_id number;
261:

Line 365: from jtf_rs_resource_extns_vl

361: cursor res_cur IS
362: select resource_name, source_email, user_id, source_id, category,
363: trunc(start_date_active) start_date_active,
364: trunc(end_date_active) end_date_active
365: from jtf_rs_resource_extns_vl
366: where resource_id = p_resource_id;
367:
368: res_rec res_cur%rowtype;
369:

Line 1244: FROM jtf_rs_group_members mem, jtf_rs_groups_b grp, jtf_rs_resource_extns res

1240: CURSOR grp_mem_cur IS
1241: SELECT mem.resource_id,
1242: greatest(l_start_date_active, res.start_date_active) grp_mem_start_date,
1243: least (nvl(l_end_date_active, l_g_miss_date), nvl(res.end_date_active, l_g_miss_date)) grp_mem_end_date
1244: FROM jtf_rs_group_members mem, jtf_rs_groups_b grp, jtf_rs_resource_extns res
1245: WHERE mem.group_id = grp.group_id
1246: AND mem.resource_id = res.resource_id
1247: AND nvl(mem.delete_flag,'N') <> 'Y'
1248: AND l_sysdate between trunc(res.start_date_active) and nvl(trunc(res.end_date_active),l_sysdate)

Line 1480: FROM JTF_RS_RESOURCE_EXTNS

1476:
1477: CURSOR c_res_active (p_resource_id IN NUMBER) IS
1478: SELECT trunc(START_DATE_ACTIVE) START_DATE_ACTIVE,
1479: trunc(END_DATE_ACTIVE) END_DATE_ACTIVE
1480: FROM JTF_RS_RESOURCE_EXTNS
1481: WHERE RESOURCE_ID = P_RESOURCE_ID AND
1482: trunc(START_DATE_ACTIVE) <= l_sysdate AND
1483: NVL(trunc(END_DATE_ACTIVE), l_sysdate) >= l_sysdate;
1484:

Line 1783: FROM jtf_rs_resource_extns

1779:
1780: CURSOR res_dates(c_resource_id NUMBER) IS
1781: SELECT trunc(start_date_active) start_date_active,
1782: trunc(end_date_active) end_date_active
1783: FROM jtf_rs_resource_extns
1784: WHERE resource_id = c_resource_id;
1785:
1786: CURSOR group_dates(c_group_id NUMBER) IS
1787: SELECT trunc(start_date_active) start_date_active,

Line 2003: FROM JTF_RS_RESOURCE_EXTNS

1999:
2000: CURSOR c_res_active (p_resource_id IN NUMBER) IS
2001: SELECT trunc(START_DATE_ACTIVE) START_DATE_ACTIVE,
2002: trunc(END_DATE_ACTIVE) END_DATE_ACTIVE
2003: FROM JTF_RS_RESOURCE_EXTNS
2004: WHERE RESOURCE_ID = P_RESOURCE_ID AND
2005: trunc(START_DATE_ACTIVE) <= l_sysdate AND
2006: NVL(trunc(END_DATE_ACTIVE), l_sysdate) >= l_sysdate;
2007: