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 1189: --Using pa_resource_list_assignments_v instead of

1185: group by typ.res_type_code
1186: having count(typ.res_type_code) > 1;
1187:
1188: --Bug 3605602
1189: --Using pa_resource_list_assignments_v instead of
1190: --pa_resource_list_assignments.
1191: CURSOR chk_wp_disable IS
1192: SELECT 'N'
1193: FROM pa_resource_lists_all_bg rl

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

1193: FROM pa_resource_lists_all_bg rl
1194: WHERE rl.resource_list_id = p_resource_list_id
1195: AND rl.use_for_wp_flag <> p_use_for_wp_flag
1196: --AND exists (select 'Y' from pa_resource_list_assignments rla
1197: AND exists (select 'Y' from pa_resource_list_assignments_v rla
1198: where rla.resource_list_id = rl.resource_list_id
1199: and rla.use_for_wp_flag = 'Y');
1200:
1201: --Bug 3605602

Line 1202: --Using pa_resource_list_assignments_v instead of

1198: where rla.resource_list_id = rl.resource_list_id
1199: and rla.use_for_wp_flag = 'Y');
1200:
1201: --Bug 3605602
1202: --Using pa_resource_list_assignments_v instead of
1203: --pa_resource_list_assignments.
1204: CURSOR chk_ctrl_changed IS
1205: SELECT 'N'
1206: FROM pa_resource_lists_all_bg rl

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

1206: FROM pa_resource_lists_all_bg rl
1207: WHERE rl.resource_list_id = p_resource_list_id
1208: AND rl.control_flag <> p_control_flag
1209: --AND exists (select 'Y' from pa_resource_list_assignments rla
1210: AND exists (select 'Y' from pa_resource_list_assignments_v rla
1211: where rla.resource_list_id = rl.resource_list_id);
1212:
1213: CURSOR chk_job_group_allow IS
1214: SELECT 'N'

Line 4956: -- Changed Pa_resource_list_assignments to pa_resource_list_assignments_v

4952: * Cursor to get all the resource_list_ID's
4953: * associated to the source project_id.
4954: **********************************************/
4955: --Bug 3494461
4956: -- Changed Pa_resource_list_assignments to pa_resource_list_assignments_v
4957: Cursor c_get_resource_list
4958: IS
4959: SELECT resource_list_id
4960: FROM pa_resource_list_assignments_v

Line 4960: FROM pa_resource_list_assignments_v

4956: -- Changed Pa_resource_list_assignments to pa_resource_list_assignments_v
4957: Cursor c_get_resource_list
4958: IS
4959: SELECT resource_list_id
4960: FROM pa_resource_list_assignments_v
4961: WHERE project_id = p_source_project_id;
4962:
4963: l_resource_list_id pa_resource_list_members.resource_list_id%TYPE;
4964: l_control_flag Varchar2(1);