DBA Data[Home] [Help]

APPS.AHL_PRD_PARTS_CHANGE_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 1155: from fnd_lookup_values_vl

1151:
1152: --To get removal reason code if menaing is provided
1153: CURSOR ahl_removal_lookup_csr(p_meaning in varchar2) IS
1154: select lookup_code
1155: from fnd_lookup_values_vl
1156: where meaning = p_meaning
1157: and lookup_type= 'AHL_REMOVAL_CODE';
1158:
1159: /*

Line 1163: from fnd_lookup_values_vl

1159: /*
1160: --to get problem code if problem meaning is provided
1161: CURSOR ahl_problem_lookup_csr(p_meaning in varchar2) IS
1162: select lookup_code
1163: from fnd_lookup_values_vl
1164: where meaning = p_meaning
1165: and lookup_type= 'REQUEST_PROBLEM_CODE';
1166:
1167: -- To get target visit id if number is provided