APPS.PA_PLANNING_RESOURCE_UTILS dependencies on PA_RESOURCE_LISTS_ALL_BG

Line 5620: from pa_resource_lists_all_bg

5616: Res_Format_Id = P_Res_Format_Id;
5617:
5618: CURSOR get_job_group_id(p_res_list_id in NUMBER) is
5619: select job_group_id
5620: from pa_resource_lists_all_bg
5621: where resource_list_id = p_res_list_id;
5622:
5623: CURSOR chk_job_in_job_group(p_job_group_id IN NUMBER,
5624: p_Job_ID in NUMBER) IS

Line 6469: FROM pa_resource_lists_all_bg

6465: *******************************************************/
6466: BEGIN
6467: SELECT control_flag
6468: INTO l_central_control
6469: FROM pa_resource_lists_all_bg
6470: WHERE resource_list_id = l_resource_list_id;
6471: EXCEPTION
6472: WHEN OTHERS THEN
6473: l_resource_list_member_id := NULL;

Line 6946: FROM pa_resource_lists_all_bg

6942: -- Added for bug 4025261
6943: BEGIN
6944: SELECT job_group_id
6945: INTO l_job_group_id
6946: FROM pa_resource_lists_all_bg
6947: WHERE resource_list_id = l_resource_list_id;
6948:
6949: SELECT 'Y'
6950: INTO l_valid_job

Line 7197: from pa_resource_lists_all_bg lst,

7193: lst.name,
7194: lst.description,
7195: l.language_code,
7196: userenv('LANG')
7197: from pa_resource_lists_all_bg lst,
7198: fnd_languages l
7199: where l.Installed_Flag in ('I', 'B')
7200: and lst.resource_list_id = p_resource_list_id
7201: and not exists (select 'Y'

Line 7222: l_res_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;

7218: p_project_id IN NUMBER,
7219: x_return_status OUT NOCOPY VARCHAR2,
7220: x_msg_count OUT NOCOPY NUMBER)
7221: IS
7222: l_res_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;
7223:
7224: --For bug 4039707
7225: CURSOR get_resource_lists IS
7226: SELECT resource_list_id FROM pa_resource_lists_all_bg

Line 7226: SELECT resource_list_id FROM pa_resource_lists_all_bg

7222: l_res_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;
7223:
7224: --For bug 4039707
7225: CURSOR get_resource_lists IS
7226: SELECT resource_list_id FROM pa_resource_lists_all_bg
7227: WHERE migration_code is not null;
7228:
7229: BEGIN
7230: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 7267: FROM pa_resource_lists_all_bg

7263:
7264: BEGIN
7265: SELECT nvl(control_flag, 'N')
7266: INTO l_central_control
7267: FROM pa_resource_lists_all_bg
7268: WHERE resource_list_id = p_resource_list_id;
7269:
7270: IF l_central_control = 'Y' THEN
7271: SELECT resource_list_member_id

Line 7461: FROM pa_resource_lists_all_bg

7457: x_msg_count := 0;
7458:
7459: SELECT control_flag
7460: INTO l_central_control
7461: FROM pa_resource_lists_all_bg
7462: WHERE resource_list_id = p_resource_list_id;
7463:
7464: IF l_central_control = 'N' THEN
7465: l_object_type := 'PROJECT';