1198: crh.ship_to_location_id,
1199: decode(crh.task_assignment_id,null,crh.resource_id,jta.resource_id),
1200: decode(crh.task_assignment_id,null,crh.resource_type,jta.resource_type_code)
1201: from jtf_task_assignments jta,
1202: csp_requirement_headers crh
1203: where jta.task_assignment_id(+) = crh.task_assignment_id
1204: and crh.requirement_header_id = p_rqmt_header_id;
1205:
1206: CURSOR get_new_context(p_new_org_id number) IS
1218: FROM HZ_CUST_ACCT_SITES_ALL cust_acct,
1219: HZ_CUST_SITE_USES_ALL site_use,
1220: hz_party_site_uses hpsu,
1221: cs_incidents_all cia,
1222: csp_requirement_headers_v req
1223: WHERE req.requirement_header_id = p_rqmt_header_id
1224: and cia.incident_id = req.incident_id
1225: and cust_acct.cust_account_id = cia.bill_to_account_id
1226: and hpsu.party_site_use_id = cia.bill_to_site_use_id