APPS.GMS_PA_API dependencies on PA_TASKS

Line 1074: from pa_tasks

1070: IF nvl(X_project_id, 0) = 0 and NVL(X_task_id,0) <> 0 THEN
1071: BEGIN
1072: SELECT project_id
1073: into X_project_id
1074: from pa_tasks
1075: where task_id = X_task_id
1076: and rownum < 2 ;
1077: EXCEPTION
1078: when no_data_found then

Line 1524: l_task_number pa_tasks.task_number%TYPE ;

1520: --
1521: l_project_id number ;
1522: l_task_id number ;
1523: l_project_number pa_projects_all.segment1%TYPE ;
1524: l_task_number pa_tasks.task_number%TYPE ;
1525: x_outcome VARCHAR2(2000) ;
1526: l_gl_accted_flag VARCHAR2(1) ;
1527: l_bud_ver_id NUMBER ;
1528: l_dummy NUMBER ;

Line 1679: from pa_tasks

1675: -- bug : 3617328 perf issue in gmspax1b.pls
1676: --
1677: cursor c_get_task_id is
1678: select task_id
1679: from pa_tasks
1680: where task_number = l_task_number
1681: and project_id = l_project_id ;
1682:
1683: --

Line 1688: from pa_tasks

1684: -- bug : 3617328 perf issue in gmspax1b.pls
1685: --
1686: cursor c_get_task_num is
1687: select task_number
1688: from pa_tasks
1689: where task_id = l_task_id ;
1690:
1691: BEGIN
1692:

Line 2244: from pa_tasks t,

2240: end if;
2241:
2242: select nvl(sponsored_flag,'N')
2243: into l_sponsored_flag
2244: from pa_tasks t,
2245: pa_projects_all p,
2246: gms_project_types gpt
2247: where p.project_id = t.project_id
2248: and gpt.project_type = p.project_type

Line 2472: from pa_tasks t

2468: -- SQL was wrong causing too many rows found
2469: -- join with pa_expenditure_items_all was removed.
2470: --
2471: select t.project_id into l_project_id
2472: from pa_tasks t
2473: where t.task_id = x_task_id ;
2474:
2475: If is_sponsored_project(l_project_id) THEN
2476: RETURN 'Y' ; -- adl is missing hence don't process that item.