31: WHERE EXISTS
32: (SELECT 'x' FROM pa_project_assignments
33: WHERE status_code = p_status_code)
34: OR EXISTS
35: (SELECT 'x' FROM pa_schedules
36: WHERE status_code = p_status_code)
37: OR EXISTS
38: (SELECT 'x' FROM pa_project_assignments
39: WHERE apprvl_status_code = p_status_code);
40:
41: SELECT 'Y', 'PA_STATUS_EXIST_IN_ASGMT'
42: INTO x_in_use_flag, x_error_message_code
43: FROM pa_project_assignments ppa,
44: pa_schedules ps
45: WHERE
46: ( ( ppa.status_code = p_status_code)
47: OR ( ps.status_code = p_status_code)
48: OR ( ppa.apprvl_status_code = p_status_code))
76: BEGIN
77: IF x_in_use_flag = 'N' THEN
78: SELECT 'Y', 'PA_STATUS_EXIST_IN_ASGMT'
79: INTO x_in_use_flag, x_error_message_code
80: FROM pa_schedules
81: WHERE status_code = p_status_code
82: AND rownum = 1;
83: END IF;
84: EXCEPTION