DBA Data[Home] [Help]

APPS.GMA_MIGRATION_UTILS dependencies on SY_REAS_CDS_B

Line 26: FROM sy_reas_cds_b

22: --====================================================================*/
23: FUNCTION get_reason_id (p_reason_code IN VARCHAR2) RETURN NUMBER IS
24: CURSOR reason_id_cur(p_reason_code IN VARCHAR2) IS
25: SELECT reason_id
26: FROM sy_reas_cds_b
27: WHERE reason_code = p_reason_code;
28: X_reason_Id NUMBER(15);
29: BEGIN
30: OPEN reason_id_cur(p_reason_code);

Line 213: FROM SY_REAS_CDS_B src

209: CURSOR reas_mst_cur IS
210: SELECT src.text_code,
211: src.reason_id,
212: src.reason_code
213: FROM SY_REAS_CDS_B src
214: WHERE src.text_code IS NOT NULL
215: and src.reason_id <> 0;
216: --
217: --- Cursor for the Organization Codes migration