APPS.CSF_ALERTS_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 667: jtf_rs_resource_extns jr

663: jt.resource_type_code,
664: jt.assignment_status_id
665: from
666: jtf_task_assignments jt,
667: jtf_rs_resource_extns jr
668: where
669: jt.task_assignment_id = v_task_asgn_id
670: and jt.resource_id = jr.resource_id
671: and category_type(jt.resource_type_code) = jr.category;

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

1397: function getUserId (p_resource_id number,
1398: p_resource_type varchar2) return number is
1399: l_user_id number;
1400: cursor c_user_id (v_resource_id number, v_category varchar2) is
1401: select user_id from jtf_rs_resource_extns where resource_id = v_resource_id and category = v_category;
1402: begin
1403: l_user_id := 0;
1404:
1405: open c_user_id (p_resource_id, category_type(p_resource_type));

Line 2889: jtf_rs_resource_extns j,

2885: cursor c_check_user_name (v_resource_id number) is
2886: select
2887: j.user_name
2888: from
2889: jtf_rs_resource_extns j,
2890: wf_roles w
2891: where
2892: j.resource_id = v_resource_id
2893: and j.user_name = w.name;