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

Line 1623: from pa_class_codes cat,

1619: select
1620: cat.class_category class_category,
1621: cat.class_code description,
1622: cat.class_code_id code
1623: from pa_class_codes cat,
1624: pa_ci_types_b typ
1625: where trunc(sysdate) between cat.start_date_active and
1626: nvl(cat.end_date_active,trunc(sysdate))
1627: and typ.ci_type_id=c_ci_type_id

Line 6666: FROM pa_class_codes cat,

6662: AND trunc(sysdate) BETWEEN start_date_active AND nvl(end_date_active, trunc(sysdate));
6663:
6664: CURSOR c_classification (p_ci_type_id NUMBER, p_class_code_id NUMBER) IS
6665: SELECT cat.class_code_id
6666: FROM pa_class_codes cat,
6667: pa_ci_types_b typ
6668: WHERE trunc(sysdate) between cat.start_date_active and nvl(cat.end_date_active,trunc(sysdate))
6669: AND typ.ci_type_id = p_ci_type_id
6670: AND cat.class_category = typ.classification_category

Line 6675: FROM pa_class_codes cat,

6671: AND cat.class_code_id = p_class_code_id;
6672:
6673: CURSOR c_reason (p_ci_type_id NUMBER, p_reason_code_id NUMBER) IS
6674: SELECT cat.class_code_id
6675: FROM pa_class_codes cat,
6676: pa_ci_types_b typ
6677: WHERE trunc(sysdate) between cat.start_date_active and nvl(cat.end_date_active,trunc(sysdate))
6678: AND typ.ci_type_id = p_ci_type_id
6679: AND cat.class_category = typ.reason_category

Line 6684: FROM pa_class_codes cat,

6680: AND cat.class_code_id = p_reason_code_id;
6681:
6682: CURSOR c_resolution (p_ci_type_id NUMBER, p_resolution_code_id NUMBER) IS
6683: SELECT cat.class_code_id
6684: FROM pa_class_codes cat,
6685: pa_ci_types_b typ
6686: WHERE trunc(sysdate) between cat.start_date_active and nvl(cat.end_date_active,trunc(sysdate))
6687: AND typ.ci_type_id = p_ci_type_id
6688: AND cat.class_category = typ.resolution_category

Line 7926: FROM pa_class_codes cat,

7922: AND trunc(sysdate) BETWEEN start_date_active AND nvl(end_date_active, trunc(sysdate));
7923:
7924: CURSOR c_classification (p_ci_type_id NUMBER, p_class_code_id NUMBER) IS
7925: SELECT cat.class_code_id
7926: FROM pa_class_codes cat,
7927: pa_ci_types_b typ
7928: WHERE trunc(sysdate) between cat.start_date_active and nvl(cat.end_date_active,trunc(sysdate))
7929: AND typ.ci_type_id = p_ci_type_id
7930: AND cat.class_category = typ.classification_category

Line 7935: FROM pa_class_codes cat,

7931: AND cat.class_code_id = p_class_code_id;
7932:
7933: CURSOR c_reason (p_ci_type_id NUMBER, p_reason_code_id NUMBER) IS
7934: SELECT cat.class_code_id
7935: FROM pa_class_codes cat,
7936: pa_ci_types_b typ
7937: WHERE trunc(sysdate) between cat.start_date_active and nvl(cat.end_date_active,trunc(sysdate))
7938: AND typ.ci_type_id = p_ci_type_id
7939: AND cat.class_category = typ.reason_category

Line 7944: FROM pa_class_codes cat,

7940: AND cat.class_code_id = p_reason_code_id;
7941:
7942: CURSOR c_resolution (p_ci_type_id NUMBER, p_resolution_code_id NUMBER) IS
7943: SELECT cat.class_code_id
7944: FROM pa_class_codes cat,
7945: pa_ci_types_b typ
7946: WHERE trunc(sysdate) between cat.start_date_active and nvl(cat.end_date_active,trunc(sysdate))
7947: AND typ.ci_type_id = p_ci_type_id
7948: AND cat.class_category = typ.resolution_category

Line 9183: FROM pa_class_codes cat,

9179: AND trunc(sysdate) BETWEEN start_date_active AND nvl(end_date_active, trunc(sysdate));
9180:
9181: CURSOR c_classification (p_ci_type_id NUMBER, p_class_code_id NUMBER) IS
9182: SELECT cat.class_code_id
9183: FROM pa_class_codes cat,
9184: pa_ci_types_b typ
9185: WHERE trunc(sysdate) between cat.start_date_active and nvl(cat.end_date_active,trunc(sysdate))
9186: AND typ.ci_type_id = p_ci_type_id
9187: AND cat.class_category = typ.classification_category

Line 9192: FROM pa_class_codes cat,

9188: AND cat.class_code_id = p_class_code_id;
9189:
9190: CURSOR c_reason (p_ci_type_id NUMBER, p_reason_code_id NUMBER) IS
9191: SELECT cat.class_code_id
9192: FROM pa_class_codes cat,
9193: pa_ci_types_b typ
9194: WHERE trunc(sysdate) between cat.start_date_active and nvl(cat.end_date_active,trunc(sysdate))
9195: AND typ.ci_type_id = p_ci_type_id
9196: AND cat.class_category = typ.reason_category

Line 9201: FROM pa_class_codes cat,

9197: AND cat.class_code_id = p_reason_code_id;
9198:
9199: CURSOR c_resolution (p_ci_type_id NUMBER, p_resolution_code_id NUMBER) IS
9200: SELECT cat.class_code_id
9201: FROM pa_class_codes cat,
9202: pa_ci_types_b typ
9203: WHERE trunc(sysdate) between cat.start_date_active and nvl(cat.end_date_active,trunc(sysdate))
9204: AND typ.ci_type_id = p_ci_type_id
9205: AND cat.class_category = typ.resolution_category