DBA Data[Home] [Help]

APPS.PA_SCHEDULE_PUB dependencies on PA_PROJECT_ASSIGNMENTS_V

Line 5147: FROM pa_project_assignments_v asgn

5143: DECODE(pending_approval_flag, 'Y', 1,
5144: DECODE(apprvl_status_code, 'ASGMT_APPRVL_CANCELED', 1, -- Bug 3235731
5145: DECODE(status_code, null, 0, -- 3235675 This is needed as is_asgmt_allow_stus_ctl_check returns N if status_code is null
5146: DECODE(pa_assignment_utils.is_asgmt_allow_stus_ctl_check(status_code, project_id, 'N'), 'N', 1, 0))))) read_only_flag
5147: FROM pa_project_assignments_v asgn
5148: WHERE asgn.resource_id = l_res_id
5149: AND (
5150: ((p_assgn_range_start_date IS NOT NULL AND p_assgn_range_end_date IS NOT NULL)
5151: AND