APPS.CSF_ALERTS_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 657: jtf_rs_resource_extns jr

653: jt.resource_type_code,
654: jt.assignment_status_id
655: from
656: jtf_task_assignments jt,
657: jtf_rs_resource_extns jr
658: where
659: jt.task_assignment_id = v_task_asgn_id
660: and jt.resource_id = jr.resource_id
661: and category_type(jt.resource_type_code) = jr.category;

Line 1391: select user_id from jtf_rs_resource_extns where resource_id = v_resource_id and category = v_category;

1387: function getUserId (p_resource_id number,
1388: p_resource_type varchar2) return number is
1389: l_user_id number;
1390: cursor c_user_id (v_resource_id number, v_category varchar2) is
1391: select user_id from jtf_rs_resource_extns where resource_id = v_resource_id and category = v_category;
1392: begin
1393: l_user_id := 0;
1394:
1395: open c_user_id (p_resource_id, category_type(p_resource_type));

Line 2879: jtf_rs_resource_extns j,

2875: cursor c_check_user_name (v_resource_id number) is
2876: select
2877: j.user_name
2878: from
2879: jtf_rs_resource_extns j,
2880: wf_roles w
2881: where
2882: j.resource_id = v_resource_id
2883: and j.user_name = w.name;