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 1643: from pa_class_codes cat

1639:
1640: cursor validate_clsfcation_code(p_classification_code number)
1641: is
1642: select cat.class_code_id code
1643: from pa_class_codes cat
1644: ,pa_ci_types_b typ
1645: where (trunc(sysdate) between cat.start_date_active and nvl(cat.end_date_active,trunc(sysdate)))
1646: and typ.ci_type_id = p_ci_type_id
1647: and cat.class_category = typ.classification_category

Line 1653: from pa_class_codes cat

1649:
1650: cursor validate_reason_code(p_reason_code number)
1651: is
1652: select cat.class_code_id code
1653: from pa_class_codes cat
1654: ,pa_ci_types_b typ
1655: where (trunc(sysdate) between cat.start_date_active and nvl(cat.end_date_active,trunc(sysdate)))
1656: and typ.ci_type_id = p_ci_type_id
1657: and cat.class_category = typ.reason_category

Line 1683: from pa_class_codes cat

1679:
1680: cursor validate_resolution_code(p_resolution_code number)
1681: is
1682: select cat.class_code_id code
1683: from pa_class_codes cat
1684: ,pa_ci_types_b typ
1685: where (trunc(sysdate) between cat.start_date_active and nvl(cat.end_date_active,trunc(sysdate)))
1686: and typ.ci_type_id= p_ci_type_id
1687: and cat.class_category=typ.resolution_category