APPS.CSM_EMAIL_QUERY_PKG dependencies on JTF_TASK_ASSIGNMENTS

Line 223: FROM jtf_task_assignments jta,

219:
220: CURSOR c_task_assignment( p_resource_id NUMBER, p_task_number VARCHAR2)
221: IS
222: SELECT count(*) over () row_count
223: FROM jtf_task_assignments jta,
224: jtf_tasks_b jtb
225: WHERE jtb.task_number = p_task_number
226: AND jtb.task_id = jta.task_id
227: AND jta.resource_id = p_resource_id;

Line 243: FROM jtf_task_assignments jta,

239: --AND rb.ROLE_CODE = 'CSF_THIRD_PARTY_SERVICE_PROVID'
240: AND rb.ROLE_CODE = 'CSF_THIRD_PARTY_ADMINISTRATOR'
241: AND rr.ROLE_RESOURCE_ID = gm.RESOURCE_ID
242: AND gm.GROUP_ID IN (SELECT jta.resource_id
243: FROM jtf_task_assignments jta,
244: jtf_tasks_b jtb
245: WHERE jtb.task_number = p_task_number
246: AND jtb.task_id = jta.task_id
247: AND jta.resource_type_code ='RS_GROUP');

Line 252: from JTF_TASK_ASSIGNMENTS JTA,

248:
249: CURSOR c_tech_task_assignment( p_resource_id NUMBER, p_task_number VARCHAR2)
250: IS
251: SELECT count(*) over () row_count
252: from JTF_TASK_ASSIGNMENTS JTA,
253: JTF_TASKS_B JTB,
254: JTF_RS_GROUP_MEMBERS jtm
255: WHERE jtb.task_number = p_task_number
256: and JTB.TASK_ID = JTA.TASK_ID

Line 829: jtf_task_assignments a,

825: jtstl.name task_status,
826: to_char(CSM_EMAIL_QUERY_PKG.ADJUST_TIME(ct.scheduled_start_date), '''|| g_date_format_mask ||''') scheduled_start_date,
827: to_char(CSM_EMAIL_QUERY_PKG.ADJUST_TIME(ct.scheduled_end_date), '''|| g_date_format_mask ||''') scheduled_end_date
828: FROM jtf_rs_resource_extns res,
829: jtf_task_assignments a,
830: jtf_tasks_b ct,
831: jtf_tasks_tl ctl,
832: cs_incidents_all_b cia,
833: hz_parties hzp,

Line 871: FROM jtf_task_assignments a,

867: ctl.task_name as subject,
868: jtstl.name task_status,
869: to_char(CSM_EMAIL_QUERY_PKG.ADJUST_TIME(ct.scheduled_start_date), '''|| g_date_format_mask ||''') scheduled_start_date,
870: to_char(CSM_EMAIL_QUERY_PKG.ADJUST_TIME(ct.scheduled_end_date), '''|| g_date_format_mask ||''') scheduled_end_date
871: FROM jtf_task_assignments a,
872: jtf_tasks_b ct,
873: jtf_tasks_tl ctl,
874: cs_incidents_all_b cia,
875: hz_parties hzp,

Line 935: FROM jtf_task_assignments jta,

931: jta.last_update_date,
932: jta.last_updated_by,
933: jta.task_assignment_id,
934: jta.assignment_status_id
935: FROM jtf_task_assignments jta,
936: jtf_tasks_b jtb
937: WHERE jtb.task_number = p_task_number
938: AND jtb.task_id = jta.task_id
939: AND jta.resource_id = p_resource_id

Line 947: FROM jtf_task_assignments jta,

943: jta.last_update_date,
944: jta.last_updated_by,
945: jta.task_assignment_id,
946: jta.assignment_status_id
947: FROM jtf_task_assignments jta,
948: jtf_tasks_b jtb
949: WHERE jtb.task_number = p_task_number
950: AND jtb.task_id = jta.task_id
951: AND jta.resource_type_code ='RS_GROUP'

Line 1855: jtf_task_assignments ass

1851: cs.contract_service_id
1852: FROM csi_item_instances csi,
1853: cs_incidents_all_b cs,
1854: jtf_tasks_b tsk,
1855: jtf_task_assignments ass
1856: WHERE csi.serial_number = p_serial_number
1857: AND csi.instance_id = cs.customer_product_id
1858: AND tsk.source_object_id = cs.incident_id
1859: AND tsk.source_object_type_code = 'SR'

Line 1870: jtf_task_assignments ass

1866: cs.contract_service_id
1867: FROM csi_item_instances csi,
1868: cs_incidents_all_b cs,
1869: jtf_tasks_b tsk,
1870: jtf_task_assignments ass
1871: WHERE csi.serial_number = p_serial_number
1872: AND csi.instance_id = cs.customer_product_id
1873: AND tsk.source_object_id = cs.incident_id
1874: AND tsk.source_object_type_code = 'SR'

Line 1896: JTF_TASK_ASSIGNMENTS ASS,

1892: cs.contract_service_id
1893: FROM csi_item_instances csi,
1894: cs_incidents_all_b cs,
1895: jtf_tasks_b tsk,
1896: JTF_TASK_ASSIGNMENTS ASS,
1897: JTF_RS_GROUP_MEMBERS jtm
1898: WHERE csi.serial_number = p_serial_number
1899: AND csi.instance_id = cs.customer_product_id
1900: AND tsk.source_object_id = cs.incident_id