APPS.PA_TASKS_MAINT_PUB dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 2469: -- p_record_version_number IN Yes Record version number from pa_proj_element_versions table

2465: -- Parameters Type Required Description and Purpose
2466: -- --------------------------- ------ -------- --------------------------------------------------------
2467: -- p_task_version_id IN Yes Element Version Id of the modified task.
2468: -- p_checked_flag IN Yes This is Y/N depending on the checkbox is checked in the page.
2469: -- p_record_version_number IN Yes Record version number from pa_proj_element_versions table
2470: -- p_project_id IN Yes Project_id of the project being updated.
2471: -- p_published_version_exists IN Yes Flag(Y/N) to indicate that whether published version exists for the project or not.
2472:
2473: PROCEDURE SET_FINANCIAL_FLAG_WRAPPER

Line 2517: pa_proj_element_versions

2513: SELECT
2514: element_version_id
2515: , financial_task_flag
2516: FROM
2517: pa_proj_element_versions
2518: WHERE
2519: project_id = l_project_id
2520: AND
2521: element_version_id

Line 2544: pa_proj_element_versions elem,

2540: SELECT
2541: element_version_id
2542: , financial_task_flag
2543: FROM
2544: pa_proj_element_versions elem,
2545: (--Get the Parents of the passed task
2546: SELECT
2547: object_id_from1 object_id
2548: FROM

Line 2574: pa_proj_element_versions

2570: SELECT
2571: element_version_id
2572: , financial_task_flag
2573: FROM
2574: pa_proj_element_versions
2575: WHERE
2576: project_id = l_project_id
2577: AND
2578: element_version_id

Line 2602: pa_proj_element_versions elem,

2598: SELECT
2599: element_version_id
2600: , financial_task_flag
2601: FROM
2602: pa_proj_element_versions elem,
2603: (
2604: SELECT
2605: object_id_to1 object_id
2606: FROM

Line 2646: pa_proj_element_versions elever

2642: allTasks.record_version_number
2643:
2644: FROM
2645: PA_TASKS allTasks,
2646: pa_proj_element_versions elever
2647: WHERE
2648: elever.element_version_id = l_task_version_id
2649: AND
2650: elever.project_id = l_project_id

Line 3187: , pa_proj_element_versions elemver

3183: , elem.proj_element_id AS PROJ_ELEMENT_ID
3184: , elemver.financial_task_flag AS FINANCIAL_TASK_FLAG
3185: FROM
3186: pa_proj_elements elem
3187: , pa_proj_element_versions elemver
3188: , pa_proj_elem_ver_structure verstruct -- Added for Bug 5438975
3189: WHERE elem.proj_element_id = elemver.proj_element_id
3190: AND elem.project_id = elemver.project_id
3191: AND elemver.element_version_id = l_element_version_id

Line 3215: pa_proj_element_versions elemver

3211: , elemver.wbs_number AS WBS_NUMBER
3212: , elemver.proj_element_id AS PROJ_ELEMENT_ID
3213: , elemver.financial_task_flag AS FINANCIAL_TASK_FLAG
3214: FROM
3215: pa_proj_element_versions elemver
3216: , pa_proj_elements projelem
3217: , pa_object_relationships por
3218: WHERE
3219: projelem.project_id = elemver.project_id