eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_CREATE_RESOURCE dependencies on PA_RESOURCE_LIST_ASSIGNMENTS_V

Line 1063: --Using pa_resource_list_assignments_v instead of

1059: group by typ.res_type_code
1060: having count(typ.res_type_code) > 1;
1061:
1062: --Bug 3605602
1063: --Using pa_resource_list_assignments_v instead of
1064: --pa_resource_list_assignments.
1065: CURSOR chk_wp_disable IS
1066: SELECT 'N'
1067: FROM pa_resource_lists_all_bg rl

Line 1071: AND exists (select 'Y' from pa_resource_list_assignments_v rla

1067: FROM pa_resource_lists_all_bg rl
1068: WHERE rl.resource_list_id = p_resource_list_id
1069: AND rl.use_for_wp_flag <> p_use_for_wp_flag
1070: --AND exists (select 'Y' from pa_resource_list_assignments rla
1071: AND exists (select 'Y' from pa_resource_list_assignments_v rla
1072: where rla.resource_list_id = rl.resource_list_id
1073: and rla.use_for_wp_flag = 'Y');
1074:
1075: --Bug 3605602

Line 1076: --Using pa_resource_list_assignments_v instead of

1072: where rla.resource_list_id = rl.resource_list_id
1073: and rla.use_for_wp_flag = 'Y');
1074:
1075: --Bug 3605602
1076: --Using pa_resource_list_assignments_v instead of
1077: --pa_resource_list_assignments.
1078: CURSOR chk_ctrl_changed IS
1079: SELECT 'N'
1080: FROM pa_resource_lists_all_bg rl

Line 1084: AND exists (select 'Y' from pa_resource_list_assignments_v rla

1080: FROM pa_resource_lists_all_bg rl
1081: WHERE rl.resource_list_id = p_resource_list_id
1082: AND rl.control_flag <> p_control_flag
1083: --AND exists (select 'Y' from pa_resource_list_assignments rla
1084: AND exists (select 'Y' from pa_resource_list_assignments_v rla
1085: where rla.resource_list_id = rl.resource_list_id);
1086:
1087: CURSOR chk_job_group_allow IS
1088: SELECT 'N'

Line 4601: -- Changed Pa_resource_list_assignments to pa_resource_list_assignments_v

4597: * Cursor to get all the resource_list_ID's
4598: * associated to the source project_id.
4599: **********************************************/
4600: --Bug 3494461
4601: -- Changed Pa_resource_list_assignments to pa_resource_list_assignments_v
4602: Cursor c_get_resource_list
4603: IS
4604: SELECT resource_list_id
4605: FROM pa_resource_list_assignments_v

Line 4605: FROM pa_resource_list_assignments_v

4601: -- Changed Pa_resource_list_assignments to pa_resource_list_assignments_v
4602: Cursor c_get_resource_list
4603: IS
4604: SELECT resource_list_id
4605: FROM pa_resource_list_assignments_v
4606: WHERE project_id = p_source_project_id;
4607:
4608: l_resource_list_id pa_resource_list_members.resource_list_id%TYPE;
4609: l_control_flag Varchar2(1);