DBA Data[Home] [Help]

APPS.PA_ALLOC_RUN dependencies on PA_ALLOC_TGT_TASKS_V

Line 10248: FROM pa_alloc_tgt_tasks_v pt

10244: CURSOR C_valid_task is
10245: SELECT '1'
10246: FROM dual
10247: WHERE EXISTS (SELECT 'Y'
10248: FROM pa_alloc_tgt_tasks_v pt
10249: WHERE pt.project_id=p_project_id
10250: and pt.task_id=p_task_id);
10251: v_ret_code varchar2(1) ;
10252: v_dummy varchar2(1);

Line 10311: FROM pa_alloc_tgt_tasks_v pt

10307: CURSOR C_valid_task is
10308: SELECT '1'
10309: FROM dual
10310: WHERE EXISTS (SELECT 'Y'
10311: FROM pa_alloc_tgt_tasks_v pt
10312: WHERE pt.project_id=p_project_id
10313: and pt.task_id=p_task_id);
10314: v_ret_code varchar2(1) ;
10315: v_dummy varchar2(1);