DBA Data[Home] [Help]

APPS.GR_PROCESS_ORDERS dependencies on SY_ORGN_MST

Line 4394: L_DEFAULT_ORGN SY_ORGN_MST.orgn_code%TYPE;

4390: L_TELEPHONE_NUMBER VARCHAR2(70);
4391:
4392: L_LABEL_CODE GR_LABELS_B.label_code%TYPE;
4393: L_ADDR_LINE SY_ADDR_MST.addr1%TYPE;
4394: L_DEFAULT_ORGN SY_ORGN_MST.orgn_code%TYPE;
4395:
4396: X_MSG_DATA VARCHAR2(2000);
4397:
4398: L_INTEGRATION VARCHAR2(1); /*B2286375 GK Changes*/

Line 4456: sy_orgn_mst om

4452: oc.evening_extension,
4453: oc.evening_area_code
4454: FROM gr_organization_contacts oc,
4455: sy_addr_mst_v oa,
4456: sy_orgn_mst om
4457: WHERE om.orgn_code = g_default_orgn
4458: AND om.addr_id = oa.addr_id
4459: AND oc.orgn_code = om.orgn_code;
4460: LocalOrgnRecord c_get_orgn_info%ROWTYPE;

Line 4487: sy_orgn_mst om

4483: FROM gr_organization_contacts oc,
4484: sy_addr_mst_v oa,
4485: hr_operating_units hou,
4486: gl_plcy_mst gl,
4487: sy_orgn_mst om
4488: WHERE om.orgn_code = g_default_orgn
4489: AND oc.orgn_code = om.orgn_code
4490: AND om.addr_id = oa.addr_id
4491: AND om.co_code = gl.co_code