1012: /* mwxx
1013: CURSOR c_from_classification
1014: is
1015: SELECT 'Y'
1016: FROM pa_ci_types_b pctb, pa_class_codes pcc
1017: WHERE pctb.ci_type_id = p_ci_type_id
1018: AND pctb.classification_category = pcc.class_category
1019: AND pcc.class_code = p_class_code;
1020: */
1022:
1023: CURSOR c_from_classification
1024: is
1025: SELECT class_code_id
1026: FROM pa_class_codes pcc,pa_ci_types_b pctb
1027: WHERE pctb.ci_type_id = p_ci_type_id
1028: AND pctb.classification_category = pcc.class_category
1029: AND pcc.class_code in (select pcc1.class_code
1030: from pa_class_codes pcc1
1026: FROM pa_class_codes pcc,pa_ci_types_b pctb
1027: WHERE pctb.ci_type_id = p_ci_type_id
1028: AND pctb.classification_category = pcc.class_category
1029: AND pcc.class_code in (select pcc1.class_code
1030: from pa_class_codes pcc1
1031: where pcc1.class_code_id = p_class_code);
1032:
1033: CURSOR c_from_reason
1034: is
1032:
1033: CURSOR c_from_reason
1034: is
1035: SELECT class_code_id
1036: FROM pa_class_codes pcc,pa_ci_types_b pctb
1037: WHERE pctb.ci_type_id = p_ci_type_id
1038: AND pctb.reason_category = pcc.class_category
1039: AND pcc.class_code in (select pcc1.class_code
1040: from pa_class_codes pcc1
1036: FROM pa_class_codes pcc,pa_ci_types_b pctb
1037: WHERE pctb.ci_type_id = p_ci_type_id
1038: AND pctb.reason_category = pcc.class_category
1039: AND pcc.class_code in (select pcc1.class_code
1040: from pa_class_codes pcc1
1041: where pcc1.class_code_id = p_reason);
1042: --Bug#13475251 start.
1043: cursor c_get_status(l_code PA_CONTROL_ITEMS.STATUS_CODE%type)
1044: is
1052:
1053: CURSOR c_from_reason
1054: is
1055: SELECT 'Y'
1056: FROM pa_ci_types_b pctb, pa_class_codes pcc
1057: WHERE pctb.ci_type_id = p_ci_type_id
1058: AND pctb.reason_category = pcc.class_category
1059: AND pcc.class_code = p_reason;
1060: */