APPS.PA_FP_PLANNING_TRANSACTION_PUB dependencies on PA_PROJ_ELEMENTS

Line 240: l_task_name pa_proj_elements.name%TYPE;

236: l_txn_accum_header_id_prm_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
237: l_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
238: -- Added for Bug 3762278
239: l_project_name pa_projects_all.name%TYPE;
240: l_task_name pa_proj_elements.name%TYPE;
241: l_resource_name pa_resource_list_members.alias%TYPE;
242:
243: l_task_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
244: l_rbs_elem_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 260: ,pa_proj_elements pt

256: SELECT ppa.name project_name
257: ,pt.name task_name
258: ,prl.alias resource_name
259: FROM pa_projects_all ppa
260: ,pa_proj_elements pt
261: ,pa_resource_list_members prl
262: ,pa_resource_assignments pra
263: WHERE pra.resource_assignment_id = p_resource_assignment_id
264: AND ppa.project_id = pra.project_id

Line 755: ,pa_proj_elements pt

751: INTO l_project_name
752: ,l_task_name
753: ,l_resource_name
754: FROM pa_projects_all ppa
755: ,pa_proj_elements pt
756: ,pa_resource_list_members prl
757: ,pa_resource_assignments pra
758: WHERE pra.resource_assignment_id = p_resource_assignment_id_tbl(i)
759: AND ppa.project_id = pra.project_id

Line 12734: ,pa_proj_elements ppe

12730: ,name
12731: ,element_number
12732: ,resource_assignment_id
12733: FROM pa_resource_assignments pra
12734: ,pa_proj_elements ppe
12735: WHERE pra.project_id = p_project_id
12736: AND pra.budget_version_id = c_budget_version_id
12737: AND pra.ta_display_flag = 'Y'
12738: AND pra.task_id = ppe.proj_element_id;

Line 12747: ,pa_proj_elements ppe

12743: ,name
12744: ,element_number
12745: ,resource_assignment_id
12746: FROM pa_resource_assignments pra
12747: ,pa_proj_elements ppe
12748: WHERE pra.project_id = p_project_id
12749: AND pra.budget_version_id = c_budget_version_id
12750: --AND pra.ta_display_flag = 'Y'
12751: AND pra.task_id = ppe.proj_element_id;