APPS.CSM_USER_EVENT_PKG dependencies on JTF_RS_RESOURCE_EXTNS

Line 330: FROM jtf_rs_resource_extns jtf_rs,

326: -- get all task assignment id's for a user
327: CURSOR l_task_assign_csr (p_user_id NUMBER)
328: IS
329: SELECT jtf_ta.task_assignment_id --get all the task assignments which are open and of type TASK
330: FROM jtf_rs_resource_extns jtf_rs,
331: jtf_task_assignments jtf_ta,
332: jtf_task_statuses_b jts_jta
333: WHERE jtf_rs.user_id = p_user_id
334: AND jtf_ta.resource_id = jtf_rs.resource_id

Line 352: FROM jtf_rs_resource_extns jtf_rs,

348: )
349: )
350: UNION ALL--Select task assignments which are for open SRs
351: SELECT jtf_ta.task_assignment_id
352: FROM jtf_rs_resource_extns jtf_rs,
353: jtf_task_assignments jtf_ta,
354: JTF_TASKS_B jt
355: WHERE jtf_rs.user_id = p_user_id
356: AND jt.task_id = jtf_ta.task_id

Line 495: jtf_rs_resource_extns jtrs,

491: FROM po_location_associations_all pla,
492: hz_cust_site_uses_all csu,
493: hz_cust_acct_sites_all cas,
494: csp_rs_cust_relations rcr,
495: jtf_rs_resource_extns jtrs,
496: hz_party_sites hps,
497: hz_locations hzl
498: WHERE csu.site_use_id = pla.site_use_id
499: AND csu.site_use_code = 'SHIP_TO'

Line 556: jtf_rs_resource_extns jtrs

552: SELECT hdr.requirement_header_id,
553: jtrs.resource_id,
554: jtrs.user_id
555: FROM csp_requirement_headers hdr,
556: jtf_rs_resource_extns jtrs
557: WHERE hdr.resource_id = jtrs.resource_id
558: AND jtrs.resource_id = p_resource_id
559: AND NOT EXISTS
560: (SELECT 1

Line 607: jtf_rs_resource_extns jtrs

603: line.requirement_line_id,
604: jtrs.user_id
605: FROM csp_requirement_headers hdr,
606: csp_requirement_lines line,
607: jtf_rs_resource_extns jtrs
608: WHERE hdr.requirement_header_id = line.requirement_header_id
609: AND hdr.resource_id = jtrs.resource_id
610: AND jtrs.resource_id = p_resource_id
611: AND NOT EXISTS