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.PA_CLIENT_EXTN_BUDGET_WF dependencies on PA_PROJECTS

Line 89: FROM pa_projects p, pa_project_types pt

85:
86: CURSOR l_project_types_csr (p_project_id NUMBER)
87: IS
88: SELECT pt.enable_budget_wf_flag
89: FROM pa_projects p, pa_project_types pt
90: WHERE p.project_id = p_project_id
91: AND p.project_type = pt.project_type;
92:
93: CURSOR l_budget_types_csr (p_budget_type_code VARCHAR2)

Line 321: FROM pa_projects

317: , project_type
318: , pm_product_code
319: , carrying_out_organization_id
320: , template_flag --Bug 6691634
321: FROM pa_projects
322: WHERE project_id = p_project_id;
323: --
324: CURSOR l_organization_csr ( p_carrying_out_organization_id NUMBER )
325: IS

Line 426: l_pm_project_reference pa_projects.pm_project_reference%TYPE;

422:
423: ItemType varchar2(30) := 'PABUDWF'; --<----Identifies the workflow process!!!
424: ItemKey varchar2(30);
425:
426: l_pm_project_reference pa_projects.pm_project_reference%TYPE;
427: l_pa_project_number pa_projects.segment1%TYPE;
428: l_project_name pa_projects.name%TYPE;
429: l_description pa_projects.description%TYPE;
430: l_project_type pa_projects.project_type%TYPE;

Line 427: l_pa_project_number pa_projects.segment1%TYPE;

423: ItemType varchar2(30) := 'PABUDWF'; --<----Identifies the workflow process!!!
424: ItemKey varchar2(30);
425:
426: l_pm_project_reference pa_projects.pm_project_reference%TYPE;
427: l_pa_project_number pa_projects.segment1%TYPE;
428: l_project_name pa_projects.name%TYPE;
429: l_description pa_projects.description%TYPE;
430: l_project_type pa_projects.project_type%TYPE;
431: l_pm_project_product_code pa_projects.pm_product_code%TYPE;

Line 428: l_project_name pa_projects.name%TYPE;

424: ItemKey varchar2(30);
425:
426: l_pm_project_reference pa_projects.pm_project_reference%TYPE;
427: l_pa_project_number pa_projects.segment1%TYPE;
428: l_project_name pa_projects.name%TYPE;
429: l_description pa_projects.description%TYPE;
430: l_project_type pa_projects.project_type%TYPE;
431: l_pm_project_product_code pa_projects.pm_product_code%TYPE;
432: l_carrying_out_org_id NUMBER;

Line 429: l_description pa_projects.description%TYPE;

425:
426: l_pm_project_reference pa_projects.pm_project_reference%TYPE;
427: l_pa_project_number pa_projects.segment1%TYPE;
428: l_project_name pa_projects.name%TYPE;
429: l_description pa_projects.description%TYPE;
430: l_project_type pa_projects.project_type%TYPE;
431: l_pm_project_product_code pa_projects.pm_product_code%TYPE;
432: l_carrying_out_org_id NUMBER;
433: l_carrying_out_org_name hr_organization_units.name%TYPE;

Line 430: l_project_type pa_projects.project_type%TYPE;

426: l_pm_project_reference pa_projects.pm_project_reference%TYPE;
427: l_pa_project_number pa_projects.segment1%TYPE;
428: l_project_name pa_projects.name%TYPE;
429: l_description pa_projects.description%TYPE;
430: l_project_type pa_projects.project_type%TYPE;
431: l_pm_project_product_code pa_projects.pm_product_code%TYPE;
432: l_carrying_out_org_id NUMBER;
433: l_carrying_out_org_name hr_organization_units.name%TYPE;
434: l_project_type_class_code pa_project_types.project_type_class_code%TYPE;

Line 431: l_pm_project_product_code pa_projects.pm_product_code%TYPE;

427: l_pa_project_number pa_projects.segment1%TYPE;
428: l_project_name pa_projects.name%TYPE;
429: l_description pa_projects.description%TYPE;
430: l_project_type pa_projects.project_type%TYPE;
431: l_pm_project_product_code pa_projects.pm_product_code%TYPE;
432: l_carrying_out_org_id NUMBER;
433: l_carrying_out_org_name hr_organization_units.name%TYPE;
434: l_project_type_class_code pa_project_types.project_type_class_code%TYPE;
435: