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 1666: from pa_tasks

1662: -- bug : 3617328 perf issue in gmspax1b.pls
1663: --
1664: cursor c_get_task_id is
1665: select task_id
1666: from pa_tasks
1667: where task_number = l_task_number
1668: and project_id = l_project_id ;
1669:
1670: --

Line 1675: from pa_tasks

1671: -- bug : 3617328 perf issue in gmspax1b.pls
1672: --
1673: cursor c_get_task_num is
1674: select task_number
1675: from pa_tasks
1676: where task_id = l_task_id ;
1677:
1678: BEGIN
1679:

Line 2231: from pa_tasks t,

2227: end if;
2228:
2229: select nvl(sponsored_flag,'N')
2230: into l_sponsored_flag
2231: from pa_tasks t,
2232: pa_projects_all p,
2233: gms_project_types gpt
2234: where p.project_id = t.project_id
2235: and gpt.project_type = p.project_type

Line 2421: from pa_tasks t

2417: -- SQL was wrong causing too many rows found
2418: -- join with pa_expenditure_items_all was removed.
2419: --
2420: select t.project_id into l_project_id
2421: from pa_tasks t
2422: where t.task_id = x_task_id ;
2423:
2424: If is_sponsored_project(l_project_id) THEN
2425: RETURN 'Y' ; -- adl is missing hence don't process that item.