APPS.MSC_GET_NAME dependencies on MSC_INTERORG_SHIP_METHODS

Line 1106: from msc_interorg_ship_methods

1102: return null;
1103: else
1104: select from_organization_id
1105: into l_org_id
1106: from msc_interorg_ship_methods
1107: where transaction_id = arg_transaction_id
1108: and plan_id = arg_plan_id;
1109:
1110: return msc_get_name.org_code(l_org_id,arg_instance_id);

Line 1124: from msc_interorg_ship_methods

1120: return null;
1121: else
1122: select to_organization_id
1123: into l_org_id
1124: from msc_interorg_ship_methods
1125: where transaction_id = arg_transaction_id
1126: and plan_id = arg_plan_id;
1127:
1128: return msc_get_name.org_code(l_org_id,arg_instance_id);

Line 1142: from msc_interorg_ship_methods

1138: return null;
1139: else
1140: select from_organization_id
1141: into l_org_id
1142: from msc_interorg_ship_methods
1143: where transaction_id = arg_transaction_id
1144: and plan_id = arg_plan_id;
1145:
1146: return l_org_id;

Line 1160: from msc_interorg_ship_methods

1156: return null;
1157: else
1158: select to_organization_id
1159: into l_org_id
1160: from msc_interorg_ship_methods
1161: where transaction_id = arg_transaction_id
1162: and plan_id = arg_plan_id;
1163:
1164: return l_org_id;

Line 1178: from msc_interorg_ship_methods

1174: return null;
1175: else
1176: select ship_method
1177: into l_ship_method
1178: from msc_interorg_ship_methods
1179: where transaction_id = arg_transaction_id
1180: and plan_id = arg_plan_id;
1181:
1182: return l_ship_method;