APPS.GR_PROCESS_DOCUMENTS_INSERTS dependencies on SY_ORGN_MST

Line 52: L_DEFAULT_ORGN SY_ORGN_MST.orgn_code%TYPE;

48: /* ------------- LOCAL VARIABLES ------------------- */
49: L_TEXT_LINE GR_WORK_WORKSHEETS.text_line%TYPE;
50: L_LABEL_CODE GR_LABELS_B.label_code%TYPE;
51: L_ADDR_LINE SY_ADDR_MST.addr1%TYPE;
52: L_DEFAULT_ORGN SY_ORGN_MST.orgn_code%TYPE;
53: L_TELEPHONE_NUMBER VARCHAR2(78);
54: L_LINE_LEN NUMBER;
55: L_LABEL_LEN NUMBER;
56: L_LANGUAGE_CODE VARCHAR(4);

Line 84: sy_orgn_mst om

80: oc.evening_fax_no,
81: oc.evening_email
82: FROM gr_organization_contacts oc,
83: sy_addr_mst oa,
84: sy_orgn_mst om
85: WHERE om.orgn_code = l_default_orgn
86: AND om.addr_id = oa.addr_id
87: AND oc.orgn_code = om.orgn_code;
88: LocalOrgnRecord c_get_orgn_info%ROWTYPE;