1707: BEGIN
1708: select displayed_field
1709: into l_displayed_status
1710: from ap_lookup_codes
1711: where lookup_type = AP_WEB_OA_ACTIVE_PKG.C_EXPENSE_REPORT_STATUS
1712: and lookup_code = l_expense_report_status;
1713:
1714: EXCEPTION
1715: WHEN NO_DATA_FOUND THEN NULL;
1987: BEGIN
1988: select displayed_field
1989: into l_displayed_status
1990: from ap_lookup_codes
1991: where lookup_type = AP_WEB_OA_ACTIVE_PKG.C_EXPENSE_REPORT_STATUS
1992: and lookup_code = l_expense_report_status;
1993:
1994: EXCEPTION
1995: WHEN NO_DATA_FOUND THEN NULL;