APPS.GML_OPM_ROI_GRP dependencies on GMA_REASON_CODE_SECURITY

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

744: select reason_code
745: From sy_reas_cds
746: Where delete_mark = 0
747: and (l_reason_code_security = 'Y')
748: AND (reason_code in (select reason_code from gma_reason_code_security
749: where (doc_type = 'PORC' or doc_type IS NULL) and
750: (responsibility_id = FND_GLOBAL.RESP_id or responsibility_id IS NULL)))
751: Union all
752: Select reason_code

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

847:
848: If p_lot_attribute_rec.reason_code IS NOT NULL THEN
849: l_trans_rec.reason_code := p_lot_attribute_rec.reason_code ;
850: Else
851: l_reason_code_security := nvl(fnd_profile.value('GMA_REASON_CODE_SECURITY'), 'N');
852: Open Get_Reason_Code;
853: Fetch Get_Reason_Code into l_trans_rec.reason_code;
854: If Get_Reason_Code%NOTFOUND Then
855: Close Get_Reason_Code;