DBA Data[Home] [Help]

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 432: l_pm_project_reference pa_projects.pm_project_reference%TYPE;

428:
429: ItemType varchar2(30) := 'PABUDWF'; --<----Identifies the workflow process!!!
430: ItemKey varchar2(30);
431:
432: l_pm_project_reference pa_projects.pm_project_reference%TYPE;
433: l_pa_project_number pa_projects.segment1%TYPE;
434: l_project_name pa_projects.name%TYPE;
435: l_description pa_projects.description%TYPE;
436: l_project_type pa_projects.project_type%TYPE;

Line 433: l_pa_project_number pa_projects.segment1%TYPE;

429: ItemType varchar2(30) := 'PABUDWF'; --<----Identifies the workflow process!!!
430: ItemKey varchar2(30);
431:
432: l_pm_project_reference pa_projects.pm_project_reference%TYPE;
433: l_pa_project_number pa_projects.segment1%TYPE;
434: l_project_name pa_projects.name%TYPE;
435: l_description pa_projects.description%TYPE;
436: l_project_type pa_projects.project_type%TYPE;
437: l_pm_project_product_code pa_projects.pm_product_code%TYPE;

Line 434: l_project_name pa_projects.name%TYPE;

430: ItemKey varchar2(30);
431:
432: l_pm_project_reference pa_projects.pm_project_reference%TYPE;
433: l_pa_project_number pa_projects.segment1%TYPE;
434: l_project_name pa_projects.name%TYPE;
435: l_description pa_projects.description%TYPE;
436: l_project_type pa_projects.project_type%TYPE;
437: l_pm_project_product_code pa_projects.pm_product_code%TYPE;
438: l_carrying_out_org_id NUMBER;

Line 435: l_description pa_projects.description%TYPE;

431:
432: l_pm_project_reference pa_projects.pm_project_reference%TYPE;
433: l_pa_project_number pa_projects.segment1%TYPE;
434: l_project_name pa_projects.name%TYPE;
435: l_description pa_projects.description%TYPE;
436: l_project_type pa_projects.project_type%TYPE;
437: l_pm_project_product_code pa_projects.pm_product_code%TYPE;
438: l_carrying_out_org_id NUMBER;
439: l_carrying_out_org_name hr_organization_units.name%TYPE;

Line 436: l_project_type pa_projects.project_type%TYPE;

432: l_pm_project_reference pa_projects.pm_project_reference%TYPE;
433: l_pa_project_number pa_projects.segment1%TYPE;
434: l_project_name pa_projects.name%TYPE;
435: l_description pa_projects.description%TYPE;
436: l_project_type pa_projects.project_type%TYPE;
437: l_pm_project_product_code pa_projects.pm_product_code%TYPE;
438: l_carrying_out_org_id NUMBER;
439: l_carrying_out_org_name hr_organization_units.name%TYPE;
440: l_project_type_class_code pa_project_types.project_type_class_code%TYPE;

Line 437: l_pm_project_product_code pa_projects.pm_product_code%TYPE;

433: l_pa_project_number pa_projects.segment1%TYPE;
434: l_project_name pa_projects.name%TYPE;
435: l_description pa_projects.description%TYPE;
436: l_project_type pa_projects.project_type%TYPE;
437: l_pm_project_product_code pa_projects.pm_product_code%TYPE;
438: l_carrying_out_org_id NUMBER;
439: l_carrying_out_org_name hr_organization_units.name%TYPE;
440: l_project_type_class_code pa_project_types.project_type_class_code%TYPE;
441: