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 1016: FROM pa_ci_types_b pctb, pa_class_codes pcc

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: */

Line 1026: FROM pa_class_codes pcc,pa_ci_types_b pctb

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

Line 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

Line 1036: FROM pa_class_codes pcc,pa_ci_types_b pctb

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

Line 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

Line 1056: FROM pa_ci_types_b pctb, pa_class_codes pcc

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: */