APPS.PA_ASSIGNMENT_UTILS dependencies on PA_SCHEDULES

Line 35: (SELECT 'x' FROM pa_schedules

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);

Line 44: pa_schedules ps

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))

Line 80: FROM pa_schedules

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