[Home] [Help]
112: SELECT c.resource_id
113: FROM jtf_rs_role_relations a,
114: jtf_rs_roles_vl b,
115: jtf_rs_resource_extns c
116: WHERE a.role_resource_type = 'RS_INDIVIDUAL'
117: AND a.role_resource_id = c.resource_id
118: AND b.role_type_code = 'CREDIT_MGMT'
119: AND a.role_id = b.role_id
120: AND b.role_code = 'CREDIT_ANALYST'
191: SELECT c.resource_id
192: FROM jtf_rs_role_relations a,
193: jtf_rs_roles_vl b,
194: jtf_rs_resource_extns c
195: WHERE a.role_resource_type = 'RS_INDIVIDUAL'
196: AND a.role_resource_id = c.resource_id
197: AND b.role_type_code = 'CREDIT_MGMT'
198: AND a.role_id = b.role_id
199: AND b.role_code = 'CREDIT_ANALYST'
272: INTO l_credit_analyst
273: FROM jtf_rs_role_relations a,
274: jtf_rs_roles_vl b,
275: jtf_rs_resource_extns c
276: WHERE a.role_resource_type = 'RS_INDIVIDUAL'
277: AND a.role_resource_id = c.resource_id
278: AND a.role_id = b.role_id
279: AND b.role_type_code = 'CREDIT_MGMT'
280: AND b.role_code = 'CREDIT_ANALYST'
300: INTO l_credit_analyst
301: FROM jtf_rs_role_relations a,
302: jtf_rs_roles_vl b,
303: jtf_rs_resource_extns c
304: WHERE a.role_resource_type = 'RS_INDIVIDUAL'
305: AND a.role_resource_id = c.resource_id
306: AND a.role_id = b.role_id
307: AND b.role_type_code = 'CREDIT_MGMT'
308: AND b.role_code = 'CREDIT_ANALYST'
349: INTO l_credit_analyst
350: FROM jtf_rs_role_relations a,
351: jtf_rs_roles_vl b,
352: jtf_rs_resource_extns c
353: WHERE a.role_resource_type = 'RS_INDIVIDUAL'
354: AND a.role_resource_id = c.resource_id
355: AND a.role_id = b.role_id
356: AND b.role_type_code = 'CREDIT_MGMT'
357: AND b.role_code = 'CREDIT_ANALYST'
376: PER_ALL_PEOPLE_F per
377: WHERE role_vl.role_type_code = 'CREDIT_MGMT'
378: and role_vl.role_code = 'CREDIT_ANALYST'
379: and role_vl.role_id = rel.role_id
380: and rel.role_resource_type = 'RS_INDIVIDUAL'
381: and rel.delete_flag <> 'Y'
382: and rel.role_resource_id = rextns.resource_id
383: and rextns.category = 'EMPLOYEE'
384: and rextns.source_id = per.person_id
823: p_cust_account_site_id IN NUMBER)
824: RETURN VARCHAR2 IS
825: CURSOR case_folder_exists IS
826: select 'Y'
827: from dual
828: where exists (select case_folder_id
829: from ar_cmgt_case_folders
830: where party_id = p_party_id
831: and cust_account_id = nvl(p_cust_account_id,-99)