APPS.GML_INTORD_LOT_STS dependencies on SY_REAS_CDS

Line 249: FROM sy_reas_cds

245: l_lot_details lot_details%ROWTYPE;
246:
247: CURSOR Get_Reason_Code IS
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

Line 257: FROM sy_reas_cds

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
257: FROM sy_reas_cds
258: WHERE delete_mark = 0;
259:
260:
261: BEGIN