APPS.GMF_GET_MAPPINGS dependencies on SY_ORGN_MST

Line 11: sv_co_code sy_orgn_mst.co_code%TYPE := 'x';

7:
8: GA_of_seg A_segment;
9: GA_of_seg_len A_seg_len;
10: GA_of_seg_pos A_seg_len;
11: sv_co_code sy_orgn_mst.co_code%TYPE := 'x';
12:
13:
14: Gn_of_seg NUMBER := -1;
15:

Line 137: x_co_code sy_orgn_mst.co_code%TYPE;

133: X_map_orgn_code VARCHAR2(4);
134: X_space VARCHAR2(10) := ' ';
135:
136:
137: x_co_code sy_orgn_mst.co_code%TYPE;
138: CURSOR Cur_get_company(v_org_code VARCHAR2) IS
139: SELECT co_code
140: FROM sy_orgn_mst
141: WHERE orgn_code = v_org_code;

Line 140: FROM sy_orgn_mst

136:
137: x_co_code sy_orgn_mst.co_code%TYPE;
138: CURSOR Cur_get_company(v_org_code VARCHAR2) IS
139: SELECT co_code
140: FROM sy_orgn_mst
141: WHERE orgn_code = v_org_code;
142:
143: CURSOR Cur_get_whse_orgn(v_whs_code VARCHAR2) IS
144: SELECT orgn_code

Line 708: x_co_code sy_orgn_mst.co_code%TYPE;

704: X_whse_orgn VARCHAR2(4);
705: X_map_whse_co VARCHAR2(4);
706: X_map_orgn_co VARCHAR2(4);
707: X_map_orgn_code VARCHAR2(4);
708: x_co_code sy_orgn_mst.co_code%TYPE;
709: CURSOR Cur_sevtacct_ttl IS
710: SELECT map_orgn_ind,
711: acct_ttl_type
712: FROM gl_sevt_ttl

Line 717: FROM sy_orgn_mst

713: WHERE sub_event_type = v_sub_event_type;
714:
715: CURSOR Cur_get_company(v_org_code VARCHAR2) IS
716: SELECT co_code
717: FROM sy_orgn_mst
718: WHERE orgn_code = v_org_code;
719:
720: CURSOR Cur_get_whse_orgn(v_whs_code VARCHAR2) IS
721: SELECT orgn_code

Line 1209: l_opm_company sy_orgn_mst.orgn_code%TYPE;

1205:
1206: l_user_id NUMBER;
1207:
1208: l_chart_of_accounts_id number(15);
1209: l_opm_company sy_orgn_mst.orgn_code%TYPE;
1210: l_opm_accu_id gl_accu_mst.acctg_unit_id%TYPE;
1211: l_opm_acct_id gl_acct_mst.acct_id%TYPE;
1212:
1213: l_opm_delimiter gl_plcy_mst.segment_delimiter%TYPE;

Line 1265: p_co_code sy_orgn_mst.orgn_code%TYPE,

1261: AND id_flex_num = p_chart_of_accounts_id
1262: AND segment_name = p_seg_name;
1263:
1264: CURSOR cur_opm_accu(
1265: p_co_code sy_orgn_mst.orgn_code%TYPE,
1266: p_acctg_unit_no gl_accu_mst.acctg_unit_no%TYPE
1267: )
1268: IS
1269: SELECT

Line 1278: p_co_code sy_orgn_mst.orgn_code%TYPE,

1274: co_code = p_co_code
1275: AND acctg_unit_no = p_acctg_unit_no;
1276:
1277: CURSOR cur_opm_acct(
1278: p_co_code sy_orgn_mst.orgn_code%TYPE,
1279: p_acct_no gl_acct_mst.acct_no%TYPE
1280: )
1281: IS
1282: SELECT