APPS.PA_TASK_UTILS dependencies on PA_PROJECTS_ALL

Line 241: from pa_projects_all

237: function get_project_name (x_project_id IN number) return varchar2
238: is
239: cursor c1 is
240: select name
241: from pa_projects_all
242: where project_id = x_project_id;
243:
244: l_project_name pa_projects_all.name%type;
245:

Line 244: l_project_name pa_projects_all.name%type;

240: select name
241: from pa_projects_all
242: where project_id = x_project_id;
243:
244: l_project_name pa_projects_all.name%type;
245:
246: begin
247: open c1;
248: fetch c1 into l_project_name;

Line 277: from pa_projects_all

273: function get_project_number (x_project_id IN number) return varchar2
274: is
275: cursor c1 is
276: select segment1
277: from pa_projects_all
278: where project_id = x_project_id;
279:
280: l_project_number pa_projects_all.segment1%type;
281:

Line 280: l_project_number pa_projects_all.segment1%type;

276: select segment1
277: from pa_projects_all
278: where project_id = x_project_id;
279:
280: l_project_number pa_projects_all.segment1%type;
281:
282: begin
283: open c1;
284: fetch c1 into l_project_number;

Line 582: FROM pa_projects_all

578: /* Added the below cursor for bug#3512486*/
579: cursor p1 is select 1 from pa_project_types_all
580: where burden_sum_dest_task_id = x_task_id
581: and org_id = (SELECT org_id --MOAC Changes: Bug 4363092: removed nvl usage with org_id
582: FROM pa_projects_all
583: where project_id = (select project_id from pa_tasks where task_id=x_task_id));
584:
585: temp number;
586: l_return_val varchar2(1);

Line 1563: from pa_projects_all

1559:
1560: cursor c1
1561: is
1562: select project_currency_code,project_rate_type,project_rate_date
1563: from pa_projects_all
1564: where project_id = p_project_id;
1565:
1566: cursor c2
1567: is

Line 1834: l_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE;

1830: Is_IEX_Installed BOOLEAN;
1831: x_project_id number;
1832:
1833: -- Progress Management Changes. Bug # 3420093.
1834: l_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE;
1835: -- Progress Management Changes. Bug # 3420093.
1836:
1837: -- Bug 3662930
1838: