DBA Data[Home] [Help]

APPS.PA_ASSIGNMENT_APPROVAL_PVT dependencies on PA_LOOKUPS

Line 1165: -- Returns meaning from pa_lookups which has p_lookup_type and p_lookup_code

1161:
1162: END Abort_Assignment_Approval;
1163:
1164: --
1165: -- Returns meaning from pa_lookups which has p_lookup_type and p_lookup_code
1166: --
1167: FUNCTION get_lookup_meaning (p_lookup_type IN VARCHAR2
1168: ,p_lookup_code IN VARCHAR2)
1169: RETURN VARCHAR2

Line 1176: FROM pa_lookups

1172: BEGIN
1173:
1174: SELECT meaning
1175: INTO l_meaning
1176: FROM pa_lookups
1177: WHERE lookup_type = p_lookup_type
1178: AND lookup_code = p_lookup_code;
1179:
1180: return l_meaning;