APPS.PA_FP_ADJUSTMENT_UTILS dependencies on PA_PROJ_ELEMENTS

Line 80: l_task_name pa_proj_elements.name%TYPE;

76:
77: -- Check when to account for 'Cost and revenue separately' with diff.
78: -- fin plan option level code..
79:
80: l_task_name pa_proj_elements.name%TYPE;
81: l_task_number pa_proj_elements.element_number%TYPE;
82:
83: --C1_Plan_Info_Rev C1_Plan_Info%ROWTYPE;
84: l_margin_code VARCHAR2(240);

Line 81: l_task_number pa_proj_elements.element_number%TYPE;

77: -- Check when to account for 'Cost and revenue separately' with diff.
78: -- fin plan option level code..
79:
80: l_task_name pa_proj_elements.name%TYPE;
81: l_task_number pa_proj_elements.element_number%TYPE;
82:
83: --C1_Plan_Info_Rev C1_Plan_Info%ROWTYPE;
84: l_margin_code VARCHAR2(240);
85: l_rev_margin_code VARCHAR2(240);

Line 155: FROM pa_proj_elements pe

151: WHERE project_id = p_project_id;
152:
153: CURSOR C1_Task_Info(p_wbs_element_id IN NUMBER) IS
154: SELECT pe.name task_name, pe.element_number task_number
155: FROM pa_proj_elements pe
156: WHERE pe.proj_element_id = p_wbs_element_id;
157:
158: CURSOR C2_Task_Info(p_resource_assignment_id IN NUMBER) IS
159: SELECT pe.name task_name, pe.element_number task_number

Line 160: FROM pa_proj_elements pe, Pa_resource_assignments ra

156: WHERE pe.proj_element_id = p_wbs_element_id;
157:
158: CURSOR C2_Task_Info(p_resource_assignment_id IN NUMBER) IS
159: SELECT pe.name task_name, pe.element_number task_number
160: FROM pa_proj_elements pe, Pa_resource_assignments ra
161: WHERE ra.task_id = pe.proj_element_id
162: and ra.resource_assignment_id = p_resource_assignment_id;
163:
164: CURSOR C1_Resource_Info(p_rbs_element_id IN NUMBER) IS