APPS.PA_CREATE_RESOURCE dependencies on PA_RES_FORMATS_B

Line 591: FROM pa_res_formats_b fmt, pa_resource_classes_b cls

587: FROM SYS.DUAL;
588:
589: CURSOR csr_get_formats IS
590: SELECT fmt.res_format_id, fmt.resource_class_id, cls.resource_class_code
591: FROM pa_res_formats_b fmt, pa_resource_classes_b cls
592: WHERE fmt.resource_class_flag = 'Y'
593: AND fmt.resource_class_id = cls.resource_class_id;
594:
595: CURSOR csr_get_class_def(p_resource_class_id NUMBER) IS

Line 1052: pa_res_formats_b fmt,

1048: ***********************************************************/
1049: CURSOR chk_wp_change_allowed IS
1050: select count(typ.res_type_code)-- , typ.res_type_code
1051: from pa_plan_rl_formats prl,
1052: pa_res_formats_b fmt,
1053: pa_res_types_b typ
1054: where prl.resource_list_id = p_resource_list_id
1055: and prl.res_format_id = fmt.res_format_id
1056: and fmt.res_type_id = typ.res_type_id