DBA Data[Home] [Help]

APPS.PA_RATE_PVT_PKG dependencies on PA_ASSIGNMENT_UTILS

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

1668: INTO l_completion_date
1669: FROM pa_schedules
1670: WHERE project_id = p_project_id
1671: AND DECODE (schedule_type_code, 'OPEN_ASSIGNMENT',
1672: pa_assignment_utils.Is_Asgmt_In_Open_Status(status_code,'OPEN_ASGMT'),
1673: 'STAFFED_ASSIGNMENT',DECODE(
1674: pa_assignment_utils.Is_Staffed_Asgmt_Cancelled(status_code,'STAFFED_ASGMT'),'Y','N','Y'),'N') = 'Y'
1675: AND DECODE(schedule_type_code,
1676: 'OPEN_ASSIGNMENT', pa_project_utils.check_prj_stus_action_allowed(

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

1670: WHERE project_id = p_project_id
1671: AND DECODE (schedule_type_code, 'OPEN_ASSIGNMENT',
1672: pa_assignment_utils.Is_Asgmt_In_Open_Status(status_code,'OPEN_ASGMT'),
1673: 'STAFFED_ASSIGNMENT',DECODE(
1674: pa_assignment_utils.Is_Staffed_Asgmt_Cancelled(status_code,'STAFFED_ASGMT'),'Y','N','Y'),'N') = 'Y'
1675: AND DECODE(schedule_type_code,
1676: 'OPEN_ASSIGNMENT', pa_project_utils.check_prj_stus_action_allowed(
1677: status_code, 'OPEN_ASGMT_PROJ_FORECASTING'),
1678: 'STAFFED_ASSIGNMENT', pa_project_utils.check_prj_stus_action_allowed(