DBA Data[Home] [Help]

APPS.AHL_PRD_PARTS_CHANGE_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 1122: from fnd_lookup_values_vl

1118:
1119: --To get removal reason code if menaing is provided
1120: CURSOR ahl_removal_lookup_csr(p_meaning in varchar2) IS
1121: select lookup_code
1122: from fnd_lookup_values_vl
1123: where meaning = p_meaning
1124: and lookup_type= 'AHL_REMOVAL_CODE';
1125:
1126: /*

Line 1130: from fnd_lookup_values_vl

1126: /*
1127: --to get problem code if problem meaning is provided
1128: CURSOR ahl_problem_lookup_csr(p_meaning in varchar2) IS
1129: select lookup_code
1130: from fnd_lookup_values_vl
1131: where meaning = p_meaning
1132: and lookup_type= 'REQUEST_PROBLEM_CODE';
1133:
1134: -- To get target visit id if number is provided