APPS.PA_TASKS_MAINT_PUB dependencies on PA_PROJ_ELEMENT_VERSIONS

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

2473: -- Parameters Type Required Description and Purpose
2474: -- --------------------------- ------ -------- --------------------------------------------------------
2475: -- p_task_version_id IN Yes Element Version Id of the modified task.
2476: -- p_checked_flag IN Yes This is Y/N depending on the checkbox is checked in the page.
2477: -- p_record_version_number IN Yes Record version number from pa_proj_element_versions table
2478: -- p_project_id IN Yes Project_id of the project being updated.
2479: -- p_published_version_exists IN Yes Flag(Y/N) to indicate that whether published version exists for the project or not.
2480:
2481: PROCEDURE SET_FINANCIAL_FLAG_WRAPPER

Line 2525: pa_proj_element_versions

2521: SELECT
2522: element_version_id
2523: , financial_task_flag
2524: FROM
2525: pa_proj_element_versions
2526: WHERE
2527: project_id = l_project_id
2528: AND
2529: element_version_id

Line 2552: pa_proj_element_versions elem,

2548: SELECT
2549: element_version_id
2550: , financial_task_flag
2551: FROM
2552: pa_proj_element_versions elem,
2553: (--Get the Parents of the passed task
2554: SELECT
2555: object_id_from1 object_id
2556: FROM

Line 2582: pa_proj_element_versions

2578: SELECT
2579: element_version_id
2580: , financial_task_flag
2581: FROM
2582: pa_proj_element_versions
2583: WHERE
2584: project_id = l_project_id
2585: AND
2586: element_version_id

Line 2610: pa_proj_element_versions elem,

2606: SELECT
2607: element_version_id
2608: , financial_task_flag
2609: FROM
2610: pa_proj_element_versions elem,
2611: (
2612: SELECT
2613: object_id_to1 object_id
2614: FROM

Line 2654: pa_proj_element_versions elever

2650: allTasks.record_version_number
2651:
2652: FROM
2653: PA_TASKS allTasks,
2654: pa_proj_element_versions elever
2655: WHERE
2656: elever.element_version_id = l_task_version_id
2657: AND
2658: elever.project_id = l_project_id

Line 3195: , pa_proj_element_versions elemver

3191: , elem.proj_element_id AS PROJ_ELEMENT_ID
3192: , elemver.financial_task_flag AS FINANCIAL_TASK_FLAG
3193: FROM
3194: pa_proj_elements elem
3195: , pa_proj_element_versions elemver
3196: , pa_proj_elem_ver_structure verstruct -- Added for Bug 5438975
3197: WHERE elem.proj_element_id = elemver.proj_element_id
3198: AND elem.project_id = elemver.project_id
3199: AND elemver.element_version_id = l_element_version_id

Line 3223: pa_proj_element_versions elemver

3219: , elemver.wbs_number AS WBS_NUMBER
3220: , elemver.proj_element_id AS PROJ_ELEMENT_ID
3221: , elemver.financial_task_flag AS FINANCIAL_TASK_FLAG
3222: FROM
3223: pa_proj_element_versions elemver
3224: , pa_proj_elements projelem
3225: , pa_object_relationships por
3226: WHERE
3227: projelem.project_id = elemver.project_id