DBA Data[Home] [Help]

APPS.PA_SCHEDULE_PUB dependencies on PA_PROJECT_ASSIGNMENTS_V

Line 4667: FROM pa_project_assignments_v asgn

4663: DECODE(pending_approval_flag, 'Y', 1,
4664: DECODE(apprvl_status_code, 'ASGMT_APPRVL_CANCELED', 1, -- Bug 3235731
4665: DECODE(status_code, null, 0, -- 3235675 This is needed as is_asgmt_allow_stus_ctl_check returns N if status_code is null
4666: DECODE(pa_assignment_utils.is_asgmt_allow_stus_ctl_check(status_code, project_id, 'N'), 'N', 1, 0))))) read_only_flag
4667: FROM pa_project_assignments_v asgn
4668: WHERE asgn.resource_id = l_res_id
4669: AND (
4670: ((p_assgn_range_start_date IS NOT NULL AND p_assgn_range_end_date IS NOT NULL)
4671: AND