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

Line 1660: from pa_class_codes cat

1656:
1657: cursor validate_clsfcation_code(p_classification_code number)
1658: is
1659: select cat.class_code_id code
1660: from pa_class_codes cat
1661: ,pa_ci_types_b typ
1662: where (trunc(sysdate) between cat.start_date_active and nvl(cat.end_date_active,trunc(sysdate)))
1663: and typ.ci_type_id = p_ci_type_id
1664: and cat.class_category = typ.classification_category

Line 1670: from pa_class_codes cat

1666:
1667: cursor validate_reason_code(p_reason_code number)
1668: is
1669: select cat.class_code_id code
1670: from pa_class_codes cat
1671: ,pa_ci_types_b typ
1672: where (trunc(sysdate) between cat.start_date_active and nvl(cat.end_date_active,trunc(sysdate)))
1673: and typ.ci_type_id = p_ci_type_id
1674: and cat.class_category = typ.reason_category

Line 1700: from pa_class_codes cat

1696:
1697: cursor validate_resolution_code(p_resolution_code number)
1698: is
1699: select cat.class_code_id code
1700: from pa_class_codes cat
1701: ,pa_ci_types_b typ
1702: where (trunc(sysdate) between cat.start_date_active and nvl(cat.end_date_active,trunc(sysdate)))
1703: and typ.ci_type_id= p_ci_type_id
1704: and cat.class_category=typ.resolution_category