DBA Data[Home] [Help]

APPS.GMA_MIGRATION_UTILS dependencies on SY_ORGN_MST

Line 55: FROM sy_orgn_mst

51: --====================================================================*/
52: FUNCTION get_organization_id (P_orgn_code IN VARCHAR2) RETURN NUMBER IS
53: CURSOR Cur_get_orgn_id IS
54: SELECT organization_id
55: FROM sy_orgn_mst
56: WHERE orgn_code = P_orgn_code;
57: X_organization_id NUMBER;
58: BEGIN
59: OPEN Cur_get_orgn_id;

Line 223: FROM SY_ORGN_MST som

219: CURSOR org_mst_cur IS
220: SELECT som.text_code,
221: som.organization_id,
222: som.orgn_code
223: FROM SY_ORGN_MST som
224: WHERE som.text_code IS NOT NULL
225: and som.migrate_as_ind=3;
226:
227:

Line 631: l_opm_table_name := 'SY_ORGN_MST';

627: p_Owner=>l_event_owner,
628: p_Event_Name=>l_event_name) = FALSE) THEN
629: /* Edit Text Migration for Grades */
630: l_table_name := 'MTL_PARAMETERS';
631: l_opm_table_name := 'SY_ORGN_MST';
632: FOR l_org_mst_rec IN org_mst_cur LOOP
633: BEGIN
634: /* Call the Attachment_main procedure */
635: /* Bug 5736539 setup text table to the correct sy text table */