APPS.CAC_VIEW_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 81: , jtf_rs_resource_extns_tl jrt

77: , jrt.resource_name ResourceName
78: FROM fnd_grants fgs
79: , fnd_menus fmu
80: , fnd_objects fos
81: , jtf_rs_resource_extns_tl jrt
82: WHERE fgs.object_id = fos.object_id -- grants joint to object
83: AND fgs.menu_id = fmu.menu_id -- grants joint to menus
84: AND fos.obj_name = 'JTF_TASK_RESOURCE'
85: AND fgs.grantee_key = b_Grantee_Key

Line 356: jtf_rs_resource_extns owner,

352: jtf_tasks_vl task_view,
353: jtf_task_statuses_vl booking_status,
354: jtf_task_types_tl task_type,
355: jtf_task_priorities_tl task_priority,
356: jtf_rs_resource_extns owner,
357: jtf_task_all_assignments booking,
358: fnd_lookups freebusy,
359: jtf_objects_tl jtf_object
360: WHERE

Line 757: jtf_rs_resource_extns owner,

753: jtf_task_priorities_tl task_priority,
754: hz_parties party,
755: hz_party_sites site,
756: hz_locations location,
757: jtf_rs_resource_extns owner,
758: jtf_task_all_assignments assignment,
759: jtf_objects_tl jtf_object
760: WHERE
761: assignment.resource_id = b_ResourceId --13475

Line 1719: , jtf_rs_resource_extns r

1715: IS
1716: CURSOR c IS
1717: SELECT a.assignment_id
1718: FROM per_assignments_f a
1719: , jtf_rs_resource_extns r
1720: WHERE r.resource_id = p_emp_resource_id
1721: AND a.person_id = r.source_id
1722: AND a.primary_flag = 'Y'
1723: AND trunc(SYSDATE) BETWEEN NVL(a.effective_start_date, trunc(SYSDATE))

Line 1744: , jtf_rs_resource_extns r

1740: IS
1741: CURSOR c IS
1742: SELECT r.resource_id
1743: FROM per_assignments_f a
1744: , jtf_rs_resource_extns r
1745: WHERE a.assignment_id = p_per_assignment_id
1746: AND r.source_id = a.person_id
1747: AND r.category = 'EMPLOYEE';
1748: BEGIN