APPS.GML_INTORD_LOT_STS dependencies on GMA_REASON_CODE_SECURITY

Line 252: AND (reason_code in (select reason_code from gma_reason_code_security

248: SELECT reason_code
249: FROM sy_reas_cds
250: WHERE delete_mark = 0
251: AND (l_reason_code_security = 'Y')
252: AND (reason_code in (select reason_code from gma_reason_code_security
253: where (doc_type = 'PORC' or doc_type IS NULL) and
254: (responsibility_id = FND_GLOBAL.RESP_id or responsibility_id IS NULL)))
255: UNION ALL
256: SELECT reason_code

Line 295: l_reason_code_security := nvl(fnd_profile.value('GMA_REASON_CODE_SECURITY'), 'N');

291: l_trans_rec.from_whse_code := p_whse_code;
292: l_trans_rec.from_location := p_location;
293: l_trans_rec.lot_status := p_to_status;
294:
295: l_reason_code_security := nvl(fnd_profile.value('GMA_REASON_CODE_SECURITY'), 'N');
296: OPEN Get_Reason_Code;
297: FETCH Get_Reason_Code into l_trans_rec.reason_code;
298: IF Get_Reason_Code%NOTFOUND THEN
299: CLOSE Get_Reason_Code;