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 11352: from pa_tasks a, pa_proj_element_versions b

11348: and p_calling_context = 'SELECT_TASKS');
11349:
11350: CURSOR top_tasks_cur (c_project_id number, c_parent_structure_version_id number) is
11351: select b.element_version_id
11352: from pa_tasks a, pa_proj_element_versions b
11353: /* Replaced pa_struct_task_wbs_v with base tables for performance reasons.
11354: * Note that financial_task_flag of pa_proj_element_versions cannot be used
11355: * since it is set to Y even for tasks that are part of fin struct ver but not
11356: * yet published. (I.e., It could be Y for tasks not present in pa_tasks too). This

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

11352: from pa_tasks a, pa_proj_element_versions b
11353: /* Replaced pa_struct_task_wbs_v with base tables for performance reasons.
11354: * Note that financial_task_flag of pa_proj_element_versions cannot be used
11355: * since it is set to Y even for tasks that are part of fin struct ver but not
11356: * yet published. (I.e., It could be Y for tasks not present in pa_tasks too). This
11357: * required a join with pa_tasks to identify true fin tasks which can be
11358: * budgeted for */
11359: where b.parent_structure_version_id = c_parent_structure_version_id
11360: and b.object_type = 'PA_TASKS'

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

11353: /* Replaced pa_struct_task_wbs_v with base tables for performance reasons.
11354: * Note that financial_task_flag of pa_proj_element_versions cannot be used
11355: * since it is set to Y even for tasks that are part of fin struct ver but not
11356: * yet published. (I.e., It could be Y for tasks not present in pa_tasks too). This
11357: * required a join with pa_tasks to identify true fin tasks which can be
11358: * budgeted for */
11359: where b.parent_structure_version_id = c_parent_structure_version_id
11360: and b.object_type = 'PA_TASKS'
11361: and a.project_id = c_project_id

Line 11360: and b.object_type = 'PA_TASKS'

11356: * yet published. (I.e., It could be Y for tasks not present in pa_tasks too). This
11357: * required a join with pa_tasks to identify true fin tasks which can be
11358: * budgeted for */
11359: where b.parent_structure_version_id = c_parent_structure_version_id
11360: and b.object_type = 'PA_TASKS'
11361: and a.project_id = c_project_id
11362: and a.project_id = b.project_id
11363: and a.task_id = b.proj_element_id
11364: and a.task_id = a.top_task_id

Line 12914: ,p_task_id IN pa_tasks.task_id%TYPE

12910: --for a given budget version id, task id and resource list member id
12911: --Returns 'Y' if the record is not already there
12912: FUNCTION DUP_EXISTS
12913: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
12914: ,p_task_id IN pa_tasks.task_id%TYPE
12915: ,p_resource_list_member_id IN pa_resource_list_members.resource_list_member_id%TYPE
12916: ,p_project_id IN pa_projects_all.project_id%TYPE)
12917: RETURN VARCHAR2
12918: IS