APPS.AHL_PRD_DF_APPR_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 1541: SELECT lookup_code, meaning FROM fnd_lookup_values_vl fnd

1537: l_defer_to_meaning VARCHAR2(80);
1538: l_defer_by_meaning VARCHAR2(80);
1539:
1540: CURSOR ctr_value_type_meaning_csr IS
1541: SELECT lookup_code, meaning FROM fnd_lookup_values_vl fnd
1542: WHERE fnd.lookup_type = 'AHL_PRD_DF_CT_VAL_TYPES';
1543:
1544:
1545: BEGIN

Line 1637: SELECT meaning FROM fnd_lookup_values_vl fnd

1633: exit_flag boolean := false;
1634: l_string VARCHAR2(30);
1635:
1636: CURSOR val_reason_meaning_csr(p_reason_code IN VARCHAR2) IS
1637: SELECT meaning FROM fnd_lookup_values_vl fnd
1638: WHERE fnd.lookup_type = 'AHL_PRD_DF_REASON_TYPES'
1639: AND fnd.lookup_code = p_reason_code;
1640:
1641: l_meaning VARCHAR2(80) := '';