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_FP_PLANNING_TRANSACTION_PUB dependencies on PA_TASKS

Line 12226: from pa_tasks a, pa_proj_element_versions b

12222: and p_calling_context = 'SELECT_TASKS');
12223:
12224: CURSOR top_tasks_cur (c_project_id number, c_parent_structure_version_id number) is
12225: select b.element_version_id
12226: from pa_tasks a, pa_proj_element_versions b
12227: /* Replaced pa_struct_task_wbs_v with base tables for performance reasons.
12228: * Note that financial_task_flag of pa_proj_element_versions cannot be used
12229: * since it is set to Y even for tasks that are part of fin struct ver but not
12230: * yet published. (I.e., It could be Y for tasks not present in pa_tasks too). This

Line 12230: * yet published. (I.e., It could be Y for tasks not present in pa_tasks too). This

12226: from pa_tasks a, pa_proj_element_versions b
12227: /* Replaced pa_struct_task_wbs_v with base tables for performance reasons.
12228: * Note that financial_task_flag of pa_proj_element_versions cannot be used
12229: * since it is set to Y even for tasks that are part of fin struct ver but not
12230: * yet published. (I.e., It could be Y for tasks not present in pa_tasks too). This
12231: * required a join with pa_tasks to identify true fin tasks which can be
12232: * budgeted for */
12233: where b.parent_structure_version_id = c_parent_structure_version_id
12234: and b.object_type = 'PA_TASKS'

Line 12231: * required a join with pa_tasks to identify true fin tasks which can be

12227: /* Replaced pa_struct_task_wbs_v with base tables for performance reasons.
12228: * Note that financial_task_flag of pa_proj_element_versions cannot be used
12229: * since it is set to Y even for tasks that are part of fin struct ver but not
12230: * yet published. (I.e., It could be Y for tasks not present in pa_tasks too). This
12231: * required a join with pa_tasks to identify true fin tasks which can be
12232: * budgeted for */
12233: where b.parent_structure_version_id = c_parent_structure_version_id
12234: and b.object_type = 'PA_TASKS'
12235: and a.project_id = c_project_id

Line 12234: and b.object_type = 'PA_TASKS'

12230: * yet published. (I.e., It could be Y for tasks not present in pa_tasks too). This
12231: * required a join with pa_tasks to identify true fin tasks which can be
12232: * budgeted for */
12233: where b.parent_structure_version_id = c_parent_structure_version_id
12234: and b.object_type = 'PA_TASKS'
12235: and a.project_id = c_project_id
12236: and a.project_id = b.project_id
12237: and a.task_id = b.proj_element_id
12238: and a.task_id = a.top_task_id

Line 13815: ,p_task_id IN pa_tasks.task_id%TYPE

13811: --for a given budget version id, task id and resource list member id
13812: --Returns 'Y' if the record is not already there
13813: FUNCTION DUP_EXISTS
13814: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
13815: ,p_task_id IN pa_tasks.task_id%TYPE
13816: ,p_resource_list_member_id IN pa_resource_list_members.resource_list_member_id%TYPE
13817: ,p_project_id IN pa_projects_all.project_id%TYPE)
13818: RETURN VARCHAR2
13819: IS