APPS.PA_FP_PLANNING_TRANSACTION_PUB dependencies on PA_PROJ_ELEMENTS

Line 184: l_task_name pa_proj_elements.name%TYPE;

180: l_txn_accum_header_id_prm_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
181: l_task_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
182: -- Added for Bug 3762278
183: l_project_name pa_projects_all.name%TYPE;
184: l_task_name pa_proj_elements.name%TYPE;
185: l_resource_name pa_resource_list_members.alias%TYPE;
186:
187: l_task_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
188: l_rbs_elem_id_rbs_prm_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 204: ,pa_proj_elements pt

200: SELECT ppa.name project_name
201: ,pt.name task_name
202: ,prl.alias resource_name
203: FROM pa_projects_all ppa
204: ,pa_proj_elements pt
205: ,pa_resource_list_members prl
206: ,pa_resource_assignments pra
207: WHERE pra.resource_assignment_id = p_resource_assignment_id
208: AND ppa.project_id = pra.project_id

Line 699: ,pa_proj_elements pt

695: INTO l_project_name
696: ,l_task_name
697: ,l_resource_name
698: FROM pa_projects_all ppa
699: ,pa_proj_elements pt
700: ,pa_resource_list_members prl
701: ,pa_resource_assignments pra
702: WHERE pra.resource_assignment_id = p_resource_assignment_id_tbl(i)
703: AND ppa.project_id = pra.project_id

Line 11860: ,pa_proj_elements ppe

11856: ,name
11857: ,element_number
11858: ,resource_assignment_id
11859: FROM pa_resource_assignments pra
11860: ,pa_proj_elements ppe
11861: WHERE pra.project_id = p_project_id
11862: AND pra.budget_version_id = c_budget_version_id
11863: AND pra.ta_display_flag = 'Y'
11864: AND pra.task_id = ppe.proj_element_id;