APPS.INV_GMI_MIGRATION dependencies on SY_REAS_CDS

Line 1752: FROM sy_reas_cds_b

1748: l_field_value := 'Reason Code = ' || cuadit.reason_code;
1749:
1750: IF cuadit.reason_code IS NOT NULL THEN
1751: SELECT reason_id INTO l_reason_id
1752: FROM sy_reas_cds_b
1753: WHERE
1754: reason_code = cuadit.reason_code;
1755: END IF;
1756:

Line 2086: FROM sy_reas_cds

2082:
2083:
2084: SELECT count(*)
2085: INTO l_count
2086: FROM sy_reas_cds
2087: WHERE
2088: reason_code = 'CNVM';
2089:
2090: IF l_count = 0 THEN

Line 2091: sy_reas_cds_pkg.insert_row (

2087: WHERE
2088: reason_code = 'CNVM';
2089:
2090: IF l_count = 0 THEN
2091: sy_reas_cds_pkg.insert_row (
2092: x_rowid => l_rowid,
2093: x_reason_code => 'CNVM',
2094: x_reason_desc2 => NULL,
2095: x_reason_type => 0,

Line 2108: UPDATE sy_reas_cds_b

2104: x_last_update_date => sysdate,
2105: x_last_updated_by => 0,
2106: x_last_update_login => NULL);
2107:
2108: UPDATE sy_reas_cds_b
2109: SET reason_id = -99
2110: WHERE reason_code = 'CNVM';
2111: END IF;
2112: COMMIT;