128: from csf_debrief_lines cdl,
129: csf_debrief_headers csf,
130: cs_transaction_types_vl ctt,
131: cs_txn_billing_types ctbt,
132: jtf_task_assignments jta,
133: jtf_tasks_b jtb,
134: hz_party_sites p,
135: hz_locations loc
136: where csf.debrief_header_id = p_debrief_header_id
146:
147:
148: select max(actual_start_date)
149: into z_start_date
150: from jtf_task_assignments
151: where resource_id = z_resource_id;
152:
153: IF p_labor_start_date > z_start_date then
154: