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 1732: l_project_id pa_projects_all.project_id%TYPE ;

1728: l_default_dist_award_number VARCHAR2(15); -- Bug 3221039
1729: l_emp_org_oride varchar2(1) ;
1730: l_emporg_id NUMBER ;
1731: l_empJob_id NUMBER ;
1732: l_project_id pa_projects_all.project_id%TYPE ;
1733: l_project_id_last pa_projects_all.project_id%TYPE ;
1734: l_project_number pa_projects_all.segment1%TYPE ;
1735: l_project_number_last pa_projects_all.segment1%TYPE ;
1736: l_task_id pa_tasks.task_id%TYPE ;

Line 1733: l_project_id_last pa_projects_all.project_id%TYPE ;

1729: l_emp_org_oride varchar2(1) ;
1730: l_emporg_id NUMBER ;
1731: l_empJob_id NUMBER ;
1732: l_project_id pa_projects_all.project_id%TYPE ;
1733: l_project_id_last pa_projects_all.project_id%TYPE ;
1734: l_project_number pa_projects_all.segment1%TYPE ;
1735: l_project_number_last pa_projects_all.segment1%TYPE ;
1736: l_task_id pa_tasks.task_id%TYPE ;
1737: l_task_id_last pa_tasks.task_id%TYPE ;

Line 1734: l_project_number pa_projects_all.segment1%TYPE ;

1730: l_emporg_id NUMBER ;
1731: l_empJob_id NUMBER ;
1732: l_project_id pa_projects_all.project_id%TYPE ;
1733: l_project_id_last pa_projects_all.project_id%TYPE ;
1734: l_project_number pa_projects_all.segment1%TYPE ;
1735: l_project_number_last pa_projects_all.segment1%TYPE ;
1736: l_task_id pa_tasks.task_id%TYPE ;
1737: l_task_id_last pa_tasks.task_id%TYPE ;
1738: l_task_number pa_tasks.task_number%TYPE ;

Line 1735: l_project_number_last pa_projects_all.segment1%TYPE ;

1731: l_empJob_id NUMBER ;
1732: l_project_id pa_projects_all.project_id%TYPE ;
1733: l_project_id_last pa_projects_all.project_id%TYPE ;
1734: l_project_number pa_projects_all.segment1%TYPE ;
1735: l_project_number_last pa_projects_all.segment1%TYPE ;
1736: l_task_id pa_tasks.task_id%TYPE ;
1737: l_task_id_last pa_tasks.task_id%TYPE ;
1738: l_task_number pa_tasks.task_number%TYPE ;
1739: l_task_number_last pa_tasks.task_number%TYPE ;

Line 1745: from pa_projects_all

1741: l_sponsored_flag pa_project_types.sponsored_flag%TYPE ; --bug 4712763
1742:
1743: cursor c_project_id is
1744: select project_id
1745: from pa_projects_all
1746: where segment1 = l_project_number ;
1747:
1748: --
1749: -- bug : 3628820 perf issue in gmsawdeb.pls

Line 1754: from pa_projects_all

1750: -- FTS on pa_projects and pa_tasks table.
1751: --
1752: cursor c_project_number is
1753: select segment1
1754: from pa_projects_all
1755: where project_id = l_project_id ;
1756: --
1757: -- bug : 3628820 perf issue in gmsawdeb.pls
1758: -- FTS on pa_projects and pa_tasks table.

Line 1781: from pa_projects_all p,

1777: -- FTS on pa_projects and pa_tasks table.
1778: --
1779: cursor c_sponsored_flag is
1780: select sponsored_flag
1781: from pa_projects_all p,
1782: gms_project_types gpt
1783: where p.project_id = l_project_id
1784: and p.project_type = gpt.project_type ;
1785: