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_RES_FORMATS_B

Line 594: FROM pa_res_formats_b fmt, pa_resource_classes_b cls

590: FROM SYS.DUAL;
591:
592: CURSOR csr_get_formats IS
593: SELECT fmt.res_format_id, fmt.resource_class_id, cls.resource_class_code
594: FROM pa_res_formats_b fmt, pa_resource_classes_b cls
595: WHERE fmt.resource_class_flag = 'Y'
596: AND fmt.resource_class_id = cls.resource_class_id;
597:
598: --Added for CBS::13535688

Line 601: FROM pa_res_formats_b fmt, pa_resource_classes_b cls

597:
598: --Added for CBS::13535688
599: CURSOR csr_get_default_format IS
600: SELECT fmt.res_format_id, fmt.resource_class_id, cls.resource_class_code
601: FROM pa_res_formats_b fmt, pa_resource_classes_b cls
602: WHERE fmt.resource_class_flag = 'Y'
603: AND fmt.resource_class_id = cls.resource_class_id
604: AND cls.resource_class_code='PEOPLE';
605:

Line 1178: pa_res_formats_b fmt,

1174: ***********************************************************/
1175: CURSOR chk_wp_change_allowed IS
1176: select count(typ.res_type_code)-- , typ.res_type_code
1177: from pa_plan_rl_formats prl,
1178: pa_res_formats_b fmt,
1179: pa_res_types_b typ
1180: where prl.resource_list_id = p_resource_list_id
1181: and prl.res_format_id = fmt.res_format_id
1182: and fmt.res_type_id = typ.res_type_id

Line 1248: FROM pa_res_formats_b fmt, pa_resource_classes_b cls

1244:
1245: --Added for CBS::13535688
1246: CURSOR csr_get_default_format IS
1247: SELECT fmt.res_format_id, fmt.resource_class_id, cls.resource_class_code
1248: FROM pa_res_formats_b fmt, pa_resource_classes_b cls
1249: WHERE fmt.resource_class_flag = 'Y'
1250: AND fmt.resource_class_id = cls.resource_class_id
1251: AND cls.resource_class_code='PEOPLE';
1252:

Line 1255: FROM pa_res_formats_b fmt, pa_resource_classes_b cls

1251: AND cls.resource_class_code='PEOPLE';
1252:
1253: CURSOR csr_get_formats IS
1254: SELECT fmt.res_format_id, fmt.resource_class_id, cls.resource_class_code
1255: FROM pa_res_formats_b fmt, pa_resource_classes_b cls
1256: WHERE fmt.resource_class_flag = 'Y'
1257: AND fmt.resource_class_id = cls.resource_class_id;
1258:
1259: CURSOR csr_get_class_def(p_resource_class_id NUMBER) IS