APPS.CSL_LOBS_ACC_PKG dependencies on JTF_RS_RESOURCE_EXTNS

Line 36: jtf_rs_resource_extns jtrs, asg_user, fnd_attached_documents fndatt,

32: CURSOR l_signature_csr(p_task_assignment_id IN number,
33: p_resource_id IN number) IS
34: SELECT distinct lob.file_id, jtrs.user_id
35: FROM jtf_task_assignments jtf, csf_debrief_headers dbfhdr,
36: jtf_rs_resource_extns jtrs, asg_user, fnd_attached_documents fndatt,
37: fnd_documents_tl fnddoc_tl, fnd_documents fnddoc, fnd_lobs lob,
38: fnd_document_categories_tl fnddoccat_tl
39: WHERE jtf.task_assignment_id = p_task_assignment_id
40: AND jtf.task_assignment_id = dbfhdr.task_assignment_id

Line 55: SELECT resource_id FROM jtf_rs_resource_extns WHERE user_id = p_user_id;

51: AND fnddoccat_tl.language = asg_user.language
52: AND fnddoccat_tl.user_name = 'Signature';
53:
54: CURSOR l_rs_resource_extns_csr (p_user_id fnd_user.user_id%type) IS
55: SELECT resource_id FROM jtf_rs_resource_extns WHERE user_id = p_user_id;
56:
57: BEGIN
58:
59: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

Line 165: SELECT resource_id FROM jtf_rs_resource_extns WHERE user_id = p_user_id;

161: AND fnddoccat_tl.language = asg_user.language
162: AND fnddoccat_tl.user_name = 'Signature';
163:
164: CURSOR l_rs_resource_extns_csr (p_user_id fnd_user.user_id%type) IS
165: SELECT resource_id FROM jtf_rs_resource_extns WHERE user_id = p_user_id;
166:
167: BEGIN
168:
169: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;