DBA Data[Home] [Help]

APPS.PA_ALLOC_RUN dependencies on PA_PROJECT_UTILS

Line 782: AND ( pa_project_utils.check_project_action_allowed( p_project_id, 'NEW_TXNS') = 'Y')

778: WHERE pt.task_id = p_task_id
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

Line 1969: ' AND pa_project_utils.check_project_action_allowed( pp.project_id, ''NEW_TXNS'') = ''Y'' ' ;

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 ' ;
1973: -- l_where_str0 := l_where_str0 || l_proj_org_str ;