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_CONTROL_ITEMS_PVT dependencies on PA_CLASS_CODES

Line 937: FROM pa_ci_types_b pctb, pa_class_codes pcc

933: /* mwxx
934: CURSOR c_from_classification
935: is
936: SELECT 'Y'
937: FROM pa_ci_types_b pctb, pa_class_codes pcc
938: WHERE pctb.ci_type_id = p_ci_type_id
939: AND pctb.classification_category = pcc.class_category
940: AND pcc.class_code = p_class_code;
941: */

Line 947: FROM pa_class_codes pcc,pa_ci_types_b pctb

943:
944: CURSOR c_from_classification
945: is
946: SELECT class_code_id
947: FROM pa_class_codes pcc,pa_ci_types_b pctb
948: WHERE pctb.ci_type_id = p_ci_type_id
949: AND pctb.classification_category = pcc.class_category
950: AND pcc.class_code in (select pcc1.class_code
951: from pa_class_codes pcc1

Line 951: from pa_class_codes pcc1

947: FROM pa_class_codes pcc,pa_ci_types_b pctb
948: WHERE pctb.ci_type_id = p_ci_type_id
949: AND pctb.classification_category = pcc.class_category
950: AND pcc.class_code in (select pcc1.class_code
951: from pa_class_codes pcc1
952: where pcc1.class_code_id = p_class_code);
953:
954: CURSOR c_from_reason
955: is

Line 957: FROM pa_class_codes pcc,pa_ci_types_b pctb

953:
954: CURSOR c_from_reason
955: is
956: SELECT class_code_id
957: FROM pa_class_codes pcc,pa_ci_types_b pctb
958: WHERE pctb.ci_type_id = p_ci_type_id
959: AND pctb.reason_category = pcc.class_category
960: AND pcc.class_code in (select pcc1.class_code
961: from pa_class_codes pcc1

Line 961: from pa_class_codes pcc1

957: FROM pa_class_codes pcc,pa_ci_types_b pctb
958: WHERE pctb.ci_type_id = p_ci_type_id
959: AND pctb.reason_category = pcc.class_category
960: AND pcc.class_code in (select pcc1.class_code
961: from pa_class_codes pcc1
962: where pcc1.class_code_id = p_reason);
963: /* mwxx
964:
965: CURSOR c_from_reason

Line 968: FROM pa_ci_types_b pctb, pa_class_codes pcc

964:
965: CURSOR c_from_reason
966: is
967: SELECT 'Y'
968: FROM pa_ci_types_b pctb, pa_class_codes pcc
969: WHERE pctb.ci_type_id = p_ci_type_id
970: AND pctb.reason_category = pcc.class_category
971: AND pcc.class_code = p_reason;
972: */