DBA Data[Home] [Help]

APPS.PA_ALLOC_RUN dependencies on PA_PROJECT_UTILS

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

786: WHERE pt.task_id = p_task_id
787: AND nvl(pt.chargeable_flag, 'N') = 'Y'
788: AND ( trunc(p_expnd_item_date) BETWEEN trunc(nvl(pt.start_date,p_expnd_item_date))
789: AND trunc(NVL(pt.completion_date, p_expnd_item_date)) )
790: AND ( pa_project_utils.check_project_action_allowed( p_project_id, 'NEW_TXNS') = 'Y')
791: AND (pa_project_stus_utils.is_project_closed( p_project_id )= 'N');
792: CURSOR C_exptype_exists(p_exp_type IN VARCHAR2) IS
793: SELECT 1
794: FROM pa_expenditure_types

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

1975: end if ;
1976: end if ;
1977: l_pc_pp_str := ' pp.project_id = pc.project_id ' ;
1978: l_where_str1 := ' pa_project_stus_utils.is_project_status_closed(pp.project_status_code)=''N'' '||
1979: ' AND pa_project_utils.check_project_action_allowed( pp.project_id, ''NEW_TXNS'') = ''Y'' ' ;
1980: l_where_str2 := ' pt.chargeable_flag= ''Y'' ' ;
1981: IF p_project_org_id is NOT NULL THEN
1982: l_where_str0 := l_where_str0 || l_proj_org_str || ' AND ' ;
1983: -- l_where_str0 := l_where_str0 || l_proj_org_str ;