352: l_status VARCHAR2(30);
353:
354: cursor c_status(p_ci_id NUMBER, p_item_type VARCHAR2) is
355: SELECT wf_failure_status_code
356: FROM pa_project_statuses ps,
357: pa_control_items ci
358: WHERE ci.ci_id = p_ci_id
359: and ci.status_code = ps.project_status_code
360: and ps.status_type = 'CONTROL_ITEM'
465: l_num_of_actions NUMBER;
466:
467: cursor c_status(p_ci_id NUMBER, p_item_type VARCHAR2) is
468: SELECT wf_success_status_code
469: FROM pa_project_statuses ps,
470: pa_control_items ci
471: WHERE ci.ci_id = p_ci_id
472: and ci.status_code = ps.project_status_code
473: and ps.status_type = 'CONTROL_ITEM'
1392: pps.project_status_name,
1393: pci.owner_id,
1394: hzp.party_name
1395: from pa_control_items pci,
1396: pa_project_statuses pps,
1397: hz_parties hzp
1398: where pci.ci_id = p_ci_id AND
1399: pci.status_code=pps.project_status_code AND
1400: hzp.party_id = pci.owner_id;