DBA Data[Home] [Help]

APPS.PA_TASK_UTILS dependencies on PA_PROJECTS_ALL

Line 396: FROM pa_projects_all

392: /* Added the below cursor for bug#3512486*/
393: cursor p1 is select 1 from pa_project_types_all
394: where burden_sum_dest_task_id = x_task_id
395: and org_id = (SELECT org_id --MOAC Changes: Bug 4363092: removed nvl usage with org_id
396: FROM pa_projects_all
397: where project_id = (select project_id from pa_tasks where task_id=x_task_id));
398:
399: temp number;
400: l_return_val varchar2(1);

Line 1351: from pa_projects_all

1347:
1348: cursor c1
1349: is
1350: select project_currency_code,project_rate_type,project_rate_date
1351: from pa_projects_all
1352: where project_id = p_project_id;
1353:
1354: cursor c2
1355: is

Line 1622: l_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE;

1618: Is_IEX_Installed BOOLEAN;
1619: x_project_id number;
1620:
1621: -- Progress Management Changes. Bug # 3420093.
1622: l_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE;
1623: -- Progress Management Changes. Bug # 3420093.
1624:
1625: -- Bug 3662930
1626: