APPS.PA_SCHEDULE_PVT dependencies on PA_RESOURCE_LIST_MEMBERS

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

3758:
3759: l_start_date DATE;
3760: l_end_date DATE;
3761:
3762: l_alias_name PA_RESOURCE_LIST_MEMBERS.ALIAS%TYPE; /*Added for 4996210 */
3763: l_total_hours NUMBER; -- Bug 5126919
3764: BEGIN
3765: l_x_return_status := FND_API.G_RET_STS_SUCCESS ;
3766: PA_SCHEDULE_UTILS.log_message(1, 'Start of the create_oasgn_schedule API ....');

Line 3800: pa_resource_list_members WHERE RESOURCE_LIST_MEMBER_ID = (SELECT RESOURCE_LIST_MEMBER_ID

3796:
3797: BEGIN
3798: IF p_task_assignment_id_tbl.COUNT > 0 THEN
3799: SELECT ALIAS INTO l_alias_name FROM
3800: pa_resource_list_members WHERE RESOURCE_LIST_MEMBER_ID = (SELECT RESOURCE_LIST_MEMBER_ID
3801: FROM pa_resource_assignments WHERE resource_assignment_id = p_task_assignment_id_tbl(1));
3802: ELSE
3803: l_alias_name := NULL;
3804: END IF;