APPS.GML_OPM_ROI_GRP dependencies on SY_REAS_CDS

Line 587: from sy_reas_cds

583:
584: IF p_lot_attribute_rec.reason_code IS NOT NULL THEN
585: BEGIN
586: select 'x' into l_temp
587: from sy_reas_cds
588: where reason_code = p_lot_attribute_rec.reason_code
589: and delete_mark = 0 ;
590:
591: EXCEPTION WHEN OTHERS THEN

Line 745: From sy_reas_cds

741: l_progress VARCHAR2(4) := '010' ;
742:
743: Cursor Get_Reason_Code IS
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

Line 753: From sy_reas_cds

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
753: From sy_reas_cds
754: Where delete_mark = 0;
755:
756: l_item_status_ctl NUMBER(5);
757: