DBA Data[Home] [Help]

APPS.PA_RATE_PVT_PKG dependencies on PA_ASSIGNMENT_UTILS

Line 1603: pa_assignment_utils.Is_Asgmt_In_Open_Status(status_code,'OPEN_ASGMT'),

1599: INTO l_completion_date
1600: FROM pa_schedules
1601: WHERE project_id = p_project_id
1602: AND DECODE (schedule_type_code, 'OPEN_ASSIGNMENT',
1603: pa_assignment_utils.Is_Asgmt_In_Open_Status(status_code,'OPEN_ASGMT'),
1604: 'STAFFED_ASSIGNMENT',DECODE(
1605: pa_assignment_utils.Is_Staffed_Asgmt_Cancelled(status_code,'STAFFED_ASGMT'),'Y','N','Y'),'N') = 'Y'
1606: AND DECODE(schedule_type_code,
1607: 'OPEN_ASSIGNMENT', pa_project_utils.check_prj_stus_action_allowed(

Line 1605: pa_assignment_utils.Is_Staffed_Asgmt_Cancelled(status_code,'STAFFED_ASGMT'),'Y','N','Y'),'N') = 'Y'

1601: WHERE project_id = p_project_id
1602: AND DECODE (schedule_type_code, 'OPEN_ASSIGNMENT',
1603: pa_assignment_utils.Is_Asgmt_In_Open_Status(status_code,'OPEN_ASGMT'),
1604: 'STAFFED_ASSIGNMENT',DECODE(
1605: pa_assignment_utils.Is_Staffed_Asgmt_Cancelled(status_code,'STAFFED_ASGMT'),'Y','N','Y'),'N') = 'Y'
1606: AND DECODE(schedule_type_code,
1607: 'OPEN_ASSIGNMENT', pa_project_utils.check_prj_stus_action_allowed(
1608: status_code, 'OPEN_ASGMT_PROJ_FORECASTING'),
1609: 'STAFFED_ASSIGNMENT', pa_project_utils.check_prj_stus_action_allowed(