APPS.PA_TASK_ASSIGNMENTS_PVT dependencies on PA_RESOURCE_LIST_MEMBERS

Line 130: l_rlm_alias pa_resource_list_members.alias%TYPE;

126: l_progress_exists varchar2(1);
127:
128: l_task_elem_version_id NUMBER;
129: l_task_name pa_proj_elements.name%TYPE;
130: l_rlm_alias pa_resource_list_members.alias%TYPE;
131:
132: CURSOR C_Task_Elem_Version_Id(p_structure_version_id IN NUMBER,
133: p_task_id in NUMBER,
134: p_project_id IN NUMBER) IS

Line 183: from pa_resource_list_members

179: L_FuncProc varchar2(2000);
180:
181: CURSOR get_resource_alias(c_resource_list_member_id IN NUMBER) IS
182: SELECT alias
183: from pa_resource_list_members
184: where resource_list_member_id = c_resource_list_member_id;
185:
186: CURSOR get_task_name(c_task_id NUMBER) IS
187: SELECT NAME

Line 198: from pa_resource_list_members a, pa_resource_assignments b, pa_budget_versions bv

194: p_project_id IN NUMBER,
195: p_wbs_version_id IN NUMBER,
196: p_resource_list_member_id IN NUMBER ) IS
197: Select a.alias, b.resource_assignment_id
198: from pa_resource_list_members a, pa_resource_assignments b, pa_budget_versions bv
199: where a.resource_list_member_id = b.resource_list_member_id
200: and b.resource_list_member_id = p_resource_list_member_id
201: and b.ta_display_flag = 'Y'
202: and b.budget_version_id = bv.budget_version_id

Line 215: from pa_resource_list_members a, pa_resource_assignments b, pa_budget_versions bv

211: p_project_id IN NUMBER,
212: p_wbs_version_id IN NUMBER,
213: p_resource_list_member_id IN NUMBER,p_cbs_element_id IN NUMBER ) IS
214: Select a.alias, b.resource_assignment_id
215: from pa_resource_list_members a, pa_resource_assignments b, pa_budget_versions bv
216: where a.resource_list_member_id = b.resource_list_member_id
217: and b.resource_list_member_id = p_resource_list_member_id
218: and b.ta_display_flag = 'Y'
219: and b.budget_version_id = bv.budget_version_id

Line 1742: ,p_resource_class_code IN PA_RESOURCE_LIST_MEMBERS.resource_class_code%TYPE

1738: ,p_extraction_type IN VARCHAR2 DEFAULT NULL -- Added for bug 13419867
1739: ,p_task_version_id IN PA_PROJ_ELEMENT_VERSIONS.element_version_id%TYPE
1740: ,p_scheduled_start IN DATE
1741: ,p_scheduled_end IN DATE
1742: ,p_resource_class_code IN PA_RESOURCE_LIST_MEMBERS.resource_class_code%TYPE
1743: ,p_resource_list_member_id IN PA_RESOURCE_LIST_MEMBERS.resource_list_member_id%TYPE
1744: --CBS Change in Derive_Task_Assignments
1745: ,p_cbs_element_id IN PA_RESOURCE_ASSIGNMENTS.cbs_element_id%TYPE DEFAULT NULL
1746: -- End CBS Change in Derive_Task_Assignments

Line 1743: ,p_resource_list_member_id IN PA_RESOURCE_LIST_MEMBERS.resource_list_member_id%TYPE

1739: ,p_task_version_id IN PA_PROJ_ELEMENT_VERSIONS.element_version_id%TYPE
1740: ,p_scheduled_start IN DATE
1741: ,p_scheduled_end IN DATE
1742: ,p_resource_class_code IN PA_RESOURCE_LIST_MEMBERS.resource_class_code%TYPE
1743: ,p_resource_list_member_id IN PA_RESOURCE_LIST_MEMBERS.resource_list_member_id%TYPE
1744: --CBS Change in Derive_Task_Assignments
1745: ,p_cbs_element_id IN PA_RESOURCE_ASSIGNMENTS.cbs_element_id%TYPE DEFAULT NULL
1746: -- End CBS Change in Derive_Task_Assignments
1747: ,p_unplanned_flag IN PA_RESOURCE_ASSIGNMENTS.unplanned_flag%TYPE

Line 2264: p_rlm_alias IN pa_resource_list_members.alias%TYPE,

2260: p_time_phase_code IN pa_proj_fp_options.cost_time_phased_code%TYPE,
2261: p_accounted_period_type IN gl_periods.period_type%TYPE,
2262: p_pa_period_type IN gl_periods.period_type%TYPE,
2263: p_task_name IN pa_proj_elements.name%TYPE,
2264: p_rlm_alias IN pa_resource_list_members.alias%TYPE,
2265: P_PERIOD_NAME IN OUT NOCOPY VARCHAR2, -- 4537865
2266: P_PERIOD_START_DATE IN OUT NOCOPY DATE, -- 4537865
2267: P_PERIOD_END_DATE IN OUT NOCOPY DATE, -- 4537865
2268: x_return_status OUT NOCOPY VARCHAR2