DBA Data[Home] [Help]

APPS.JTF_TTY_ALIGN_WEBADI_INT_PKG dependencies on JTF_RS_RESOURCE_EXTNS

Line 277: jtf_rs_resource_extns_vl rsc,

273: rol.role_name, ap.rsc_role_code role_code
274: from JTF_TTY_ALIGN_ACCTS aa,
275: JTF_TTY_PTERR_ACCTS pa,
276: JTF_TTY_ALIGN_PTERR ap,
277: jtf_rs_resource_extns_vl rsc,
278: jtf_rs_groups_vl grp,
279: jtf_rs_roles_vl rol
280: where aa.terr_group_account_id = tgaid
281: and aa.alignment_id = align_id

Line 303: select resource_id into salesMgr from jtf_rs_resource_extns

299:
300: select jtf_tty_interface_s.nextval into SEQ from dual;
301:
302: begin
303: select resource_id into salesMgr from jtf_rs_resource_extns
304: where user_id = to_number(p_userid);
305:
306: exception
307: when no_data_found then