APPS.PA_ALLOC_RUN dependencies on PA_PROJECT_STUS_UTILS

Line 783: AND (pa_project_stus_utils.is_project_closed( p_project_id )= 'N');

779: AND nvl(pt.chargeable_flag, 'N') = 'Y'
780: AND ( trunc(p_expnd_item_date) BETWEEN trunc(nvl(pt.start_date,p_expnd_item_date))
781: AND trunc(NVL(pt.completion_date, p_expnd_item_date)) )
782: AND ( pa_project_utils.check_project_action_allowed( p_project_id, 'NEW_TXNS') = 'Y')
783: AND (pa_project_stus_utils.is_project_closed( p_project_id )= 'N');
784: CURSOR C_exptype_exists(p_exp_type IN VARCHAR2) IS
785: SELECT 1
786: FROM pa_expenditure_types
787: WHERE expenditure_type = p_exp_type

Line 1217: l_where_str1 := ' pa_project_stus_utils.is_project_status_closed(pp.project_status_code)=''N''' ;

1213: l_from_str1 := ' From pa_project_classes pc, pa_tasks pt, pa_projects pp' ;
1214: l_from_str2 := ' From pa_tasks pt, pa_projects pp' ;
1215: l_pc_pp_str := ' pp.project_id = pc.project_id ' ;
1216: l_where_str0 := ' where pp.project_id = pt.project_id AND ' ;
1217: l_where_str1 := ' pa_project_stus_utils.is_project_status_closed(pp.project_status_code)=''N''' ;
1218: l_where_str2 := ' pa_task_utils.check_child_exists(pt.task_id)=0' ;
1219: IF p_project_org_id is NOT NULL THEN
1220: l_where_str0 := l_where_str0 || l_proj_org_str || ' AND ' ;
1221: -- l_where_str0 := l_where_str0 || l_proj_org_str ;

Line 1968: l_where_str1 := ' pa_project_stus_utils.is_project_status_closed(pp.project_status_code)=''N'' '||

1964: l_where_str0 := l_where_str0 || 'pcou.business_group_id = pcou.recvr_business_group_id AND ' ;
1965: end if ;
1966: end if ;
1967: l_pc_pp_str := ' pp.project_id = pc.project_id ' ;
1968: l_where_str1 := ' pa_project_stus_utils.is_project_status_closed(pp.project_status_code)=''N'' '||
1969: ' AND pa_project_utils.check_project_action_allowed( pp.project_id, ''NEW_TXNS'') = ''Y'' ' ;
1970: l_where_str2 := ' pt.chargeable_flag= ''Y'' ' ;
1971: IF p_project_org_id is NOT NULL THEN
1972: l_where_str0 := l_where_str0 || l_proj_org_str || ' AND ' ;