eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMS_AWARD_DIST_ENG dependencies on PA_PROJECTS_ALL

Line 1598: l_project_id pa_projects_all.project_id%TYPE ;

1594: l_default_dist_award_number VARCHAR2(15); -- Bug 3221039
1595: l_emp_org_oride varchar2(1) ;
1596: l_emporg_id NUMBER ;
1597: l_empJob_id NUMBER ;
1598: l_project_id pa_projects_all.project_id%TYPE ;
1599: l_project_id_last pa_projects_all.project_id%TYPE ;
1600: l_project_number pa_projects_all.segment1%TYPE ;
1601: l_project_number_last pa_projects_all.segment1%TYPE ;
1602: l_task_id pa_tasks.task_id%TYPE ;

Line 1599: l_project_id_last pa_projects_all.project_id%TYPE ;

1595: l_emp_org_oride varchar2(1) ;
1596: l_emporg_id NUMBER ;
1597: l_empJob_id NUMBER ;
1598: l_project_id pa_projects_all.project_id%TYPE ;
1599: l_project_id_last pa_projects_all.project_id%TYPE ;
1600: l_project_number pa_projects_all.segment1%TYPE ;
1601: l_project_number_last pa_projects_all.segment1%TYPE ;
1602: l_task_id pa_tasks.task_id%TYPE ;
1603: l_task_id_last pa_tasks.task_id%TYPE ;

Line 1600: l_project_number pa_projects_all.segment1%TYPE ;

1596: l_emporg_id NUMBER ;
1597: l_empJob_id NUMBER ;
1598: l_project_id pa_projects_all.project_id%TYPE ;
1599: l_project_id_last pa_projects_all.project_id%TYPE ;
1600: l_project_number pa_projects_all.segment1%TYPE ;
1601: l_project_number_last pa_projects_all.segment1%TYPE ;
1602: l_task_id pa_tasks.task_id%TYPE ;
1603: l_task_id_last pa_tasks.task_id%TYPE ;
1604: l_task_number pa_tasks.task_number%TYPE ;

Line 1601: l_project_number_last pa_projects_all.segment1%TYPE ;

1597: l_empJob_id NUMBER ;
1598: l_project_id pa_projects_all.project_id%TYPE ;
1599: l_project_id_last pa_projects_all.project_id%TYPE ;
1600: l_project_number pa_projects_all.segment1%TYPE ;
1601: l_project_number_last pa_projects_all.segment1%TYPE ;
1602: l_task_id pa_tasks.task_id%TYPE ;
1603: l_task_id_last pa_tasks.task_id%TYPE ;
1604: l_task_number pa_tasks.task_number%TYPE ;
1605: l_task_number_last pa_tasks.task_number%TYPE ;

Line 1611: from pa_projects_all

1607: l_sponsored_flag pa_project_types.sponsored_flag%TYPE ; --bug 4712763
1608:
1609: cursor c_project_id is
1610: select project_id
1611: from pa_projects_all
1612: where segment1 = l_project_number ;
1613:
1614: --
1615: -- bug : 3628820 perf issue in gmsawdeb.pls

Line 1620: from pa_projects_all

1616: -- FTS on pa_projects and pa_tasks table.
1617: --
1618: cursor c_project_number is
1619: select segment1
1620: from pa_projects_all
1621: where project_id = l_project_id ;
1622: --
1623: -- bug : 3628820 perf issue in gmsawdeb.pls
1624: -- FTS on pa_projects and pa_tasks table.

Line 1647: from pa_projects_all p,

1643: -- FTS on pa_projects and pa_tasks table.
1644: --
1645: cursor c_sponsored_flag is
1646: select sponsored_flag
1647: from pa_projects_all p,
1648: gms_project_types gpt
1649: where p.project_id = l_project_id
1650: and p.project_type = gpt.project_type ;
1651: