APPS.PA_CREATE_RESOURCE dependencies on PA_RESOURCE_CLASSES_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 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