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_ADJUSTMENT_UTILS dependencies on PA_PROJ_FP_OPTIONS

Line 137: PA_PROJ_FP_OPTIONS C

133: FROM
134: PA_FIN_PLAN_TYPES_B A,
135: PA_FIN_PLAN_TYPES_TL A1,
136: PA_BUDGET_VERSIONS B,
137: PA_PROJ_FP_OPTIONS C
138: WHERE
139: A.FIN_PLAN_TYPE_ID = B.FIN_PLAN_TYPE_ID
140: AND A.FIN_PLAN_TYPE_ID = A1.FIN_PLAN_TYPE_ID
141: AND B.PROJECT_ID = C.PROJECT_ID

Line 180: l_workplan_costs_enabled_flag pa_proj_fp_options.track_workplan_costs_flag%TYPE;

176:
177: l_structure_version_id varchar2(2000);
178: l_object_type pa_proj_element_versions.object_type%TYPE;
179: l_project_level_node_flag varchar2(1) := 'N';
180: l_workplan_costs_enabled_flag pa_proj_fp_options.track_workplan_costs_flag%TYPE;
181:
182: BEGIN
183: --dbms_output.put_line('in sum test test1');
184:

Line 738: from pji_rbs_denorm rbs, pa_proj_fp_options fp, pa_resource_assignments ra, pa_budget_lines bl

734: -- RBS only - Rollup
735: CURSOR C_RBS_RES_ID_ROLL(p_budget_version_id IN NUMBER, p_rbs_element_id IN NUMBER,
736: p_rbs_version_id IN NUMBER) IS
737: Select distinct ra.resource_assignment_id, bl.TXN_CURRENCY_CODE
738: from pji_rbs_denorm rbs, pa_proj_fp_options fp, pa_resource_assignments ra, pa_budget_lines bl
739: where ra.resource_assignment_id = bl.resource_assignment_id
740: and fp.fin_plan_version_id = ra.budget_version_id
741: and rbs.struct_version_id = fp.rbs_version_id
742: and rbs.sub_id = ra.rbs_element_id

Line 751: from pji_rbs_denorm rbs, pa_proj_fp_options fp, pa_resource_assignments ra, pa_budget_lines bl

747: -- RBS only - Self-node
748: CURSOR C_RBS_RES_ID_SELF(p_budget_version_id IN NUMBER, p_rbs_element_id IN NUMBER,
749: p_rbs_version_id IN NUMBER) IS
750: Select distinct ra.resource_assignment_id, bl.TXN_CURRENCY_CODE
751: from pji_rbs_denorm rbs, pa_proj_fp_options fp, pa_resource_assignments ra, pa_budget_lines bl
752: where ra.resource_assignment_id = bl.resource_assignment_id
753: and fp.fin_plan_version_id = ra.budget_version_id
754: and rbs.struct_version_id = fp.rbs_version_id
755: and rbs.sub_id = ra.rbs_element_id

Line 766: from pji_rbs_denorm rbs, pji_xbs_denorm xbs, pa_proj_fp_options fp, pa_resource_assignments ra, pa_budget_lines bl

762: CURSOR C_BOTH_RES_ID_ROLL_ROLL(p_budget_version_id IN NUMBER, p_wbs_element_id IN NUMBER,
763: p_rbs_element_id IN NUMBER, p_rbs_version_id IN NUMBER,
764: p_wbs_structure_version_id IN NUMBER) IS
765: Select distinct ra.resource_assignment_id, bl.TXN_CURRENCY_CODE
766: from pji_rbs_denorm rbs, pji_xbs_denorm xbs, pa_proj_fp_options fp, pa_resource_assignments ra, pa_budget_lines bl
767: where ra.resource_assignment_id = bl.resource_assignment_id
768: and rbs.struct_version_id = fp.rbs_version_id
769: and rbs.sub_id = ra.rbs_element_id
770: and xbs.sub_emt_id = ra.task_id

Line 784: from pji_rbs_denorm rbs, pji_xbs_denorm xbs, pa_proj_fp_options fp, pa_resource_assignments ra, pa_budget_lines bl

780: CURSOR C_BOTH_RES_ID_ROLL_SELF(p_budget_version_id IN NUMBER, p_wbs_element_id IN NUMBER,
781: p_rbs_element_id IN NUMBER, p_rbs_version_id IN NUMBER,
782: p_wbs_structure_version_id IN NUMBER) IS
783: Select distinct ra.resource_assignment_id, bl.TXN_CURRENCY_CODE
784: from pji_rbs_denorm rbs, pji_xbs_denorm xbs, pa_proj_fp_options fp, pa_resource_assignments ra, pa_budget_lines bl
785: where ra.resource_assignment_id = bl.resource_assignment_id
786: and rbs.struct_version_id = fp.rbs_version_id
787: and rbs.sub_id = ra.rbs_element_id
788: and xbs.sub_emt_id = ra.task_id

Line 803: from pji_rbs_denorm rbs, pji_xbs_denorm xbs, pa_proj_fp_options fp, pa_resource_assignments ra, pa_budget_lines bl

799: CURSOR C_BOTH_RES_ID_SELF_ROLL(p_budget_version_id IN NUMBER, p_wbs_element_id IN NUMBER,
800: p_rbs_element_id IN NUMBER, p_rbs_version_id IN NUMBER,
801: p_wbs_structure_version_id IN NUMBER) IS
802: Select distinct ra.resource_assignment_id, bl.TXN_CURRENCY_CODE
803: from pji_rbs_denorm rbs, pji_xbs_denorm xbs, pa_proj_fp_options fp, pa_resource_assignments ra, pa_budget_lines bl
804: where ra.resource_assignment_id = bl.resource_assignment_id
805: and rbs.struct_version_id = fp.rbs_version_id
806: and rbs.sub_id = ra.rbs_element_id
807: and xbs.sub_emt_id = ra.task_id

Line 822: from pji_rbs_denorm rbs, pji_xbs_denorm xbs, pa_proj_fp_options fp, pa_resource_assignments ra, pa_budget_lines bl

818: CURSOR C_BOTH_RES_ID_SELF_SELF(p_budget_version_id IN NUMBER, p_wbs_element_id IN NUMBER,
819: p_rbs_element_id IN NUMBER, p_rbs_version_id IN NUMBER,
820: p_wbs_structure_version_id IN NUMBER) IS
821: Select distinct ra.resource_assignment_id, bl.TXN_CURRENCY_CODE
822: from pji_rbs_denorm rbs, pji_xbs_denorm xbs, pa_proj_fp_options fp, pa_resource_assignments ra, pa_budget_lines bl
823: where ra.resource_assignment_id = bl.resource_assignment_id
824: and rbs.struct_version_id = fp.rbs_version_id
825: and rbs.sub_id = ra.rbs_element_id
826: and xbs.sub_emt_id = ra.task_id

Line 841: from pji_rbs_denorm rbs, pa_proj_fp_options fp, pa_resource_assignments ra, pa_budget_lines bl

837: -- Both - WBS Project Level Self-node RBS Rollup
838: CURSOR C_BOTH_RES_ID_PROJ_ROLL(p_budget_version_id IN NUMBER, p_rbs_element_id IN NUMBER,
839: p_rbs_version_id IN NUMBER) IS
840: Select distinct ra.resource_assignment_id, bl.TXN_CURRENCY_CODE
841: from pji_rbs_denorm rbs, pa_proj_fp_options fp, pa_resource_assignments ra, pa_budget_lines bl
842: where ra.resource_assignment_id = bl.resource_assignment_id
843: and fp.fin_plan_version_id = ra.budget_version_id
844: and rbs.struct_version_id = fp.rbs_version_id
845: and rbs.sub_id = ra.rbs_element_id

Line 855: from pji_rbs_denorm rbs, pa_proj_fp_options fp, pa_resource_assignments ra, pa_budget_lines bl

851: -- Both - WBS Project Level Self-node RBS Self-node
852: CURSOR C_BOTH_RES_ID_PROJ_SELF(p_budget_version_id IN NUMBER, p_rbs_element_id IN NUMBER,
853: p_rbs_version_id IN NUMBER) IS
854: Select distinct ra.resource_assignment_id, bl.TXN_CURRENCY_CODE
855: from pji_rbs_denorm rbs, pa_proj_fp_options fp, pa_resource_assignments ra, pa_budget_lines bl
856: where ra.resource_assignment_id = bl.resource_assignment_id
857: and fp.fin_plan_version_id = ra.budget_version_id
858: and rbs.struct_version_id = fp.rbs_version_id
859: and rbs.sub_id = ra.rbs_element_id