APPS.PA_SCHEDULE_PVT dependencies on PA_RESOURCE_LIST_MEMBERS

Line 4048: l_alias_name PA_RESOURCE_LIST_MEMBERS.ALIAS%TYPE; /*Added for 4996210 */

4044:
4045: l_start_date DATE;
4046: l_end_date DATE;
4047:
4048: l_alias_name PA_RESOURCE_LIST_MEMBERS.ALIAS%TYPE; /*Added for 4996210 */
4049: l_total_hours NUMBER; -- Bug 5126919
4050: BEGIN
4051: l_x_return_status := FND_API.G_RET_STS_SUCCESS ;
4052: PA_SCHEDULE_UTILS.log_message(1, 'Start of the create_oasgn_schedule API ....');

Line 4086: pa_resource_list_members WHERE RESOURCE_LIST_MEMBER_ID = (SELECT RESOURCE_LIST_MEMBER_ID

4082:
4083: BEGIN
4084: IF p_task_assignment_id_tbl.COUNT > 0 THEN
4085: SELECT ALIAS INTO l_alias_name FROM
4086: pa_resource_list_members WHERE RESOURCE_LIST_MEMBER_ID = (SELECT RESOURCE_LIST_MEMBER_ID
4087: FROM pa_resource_assignments WHERE resource_assignment_id = p_task_assignment_id_tbl(1));
4088: ELSE
4089: l_alias_name := NULL;
4090: END IF;